Cannot create >64k shards in hash-partitioned table
Open
- Dominant language
- C
- Stars
- 12.8k
- Forks
- 794
- Avg merge
- 2d 14h
- Merged PRs (30d)
- 31
Description
I was wondering how many shards you could create in a hash-partitioned table. It seems to die around 64k shards with the following error.
```
postgres=# SELECT master_create_worker_shards('muchos',1000000,1);
WARNING: out of shared memory
ERROR: out of shared memory
HINT: You might need to increase max_locks_per_transaction.
Time: 865210.233 ms
```
Contributor guide
Assessment
This issue has not been assessed yet.