Hello Team,
Firstly, I want to thank you all for the amazing help.
I need your guidance with PostgreSQL. So, I have a 3-nodes patroni cluster running PostgreSQL 12.9 version. I got some errors related to a memory issue.
ERROR: could not resize shared memory segment "/PostgreSQL.346141036" to 16776236 bytes: No space left on device
FATAL: out of memory
DETAIL: Failed on request of size 128 in-memory context "CacheMemoryContext"
My PostgreSQL parameters related to memory;
work_mem : 128MB
shared_buffer: 16GB
effective_cache_size: 200GB
maintenance_work_mem: 2GB
My server profile:
free -g
total used free shared buff/cache available
Mem: 377 28 22 0 326 347
Swap: 127 0 127
df
tmpfs 189G 2.0M 189G 1% /dev/shm
What do you think about this? Can you advise some hints?
Best regards,
KB