* Konstantin Malanchev <hom...@gmail.com> [2019-07-09 11:51]: > Hello, > > I'm running PostgreSQL 11.4 on Linux 4.12.14 and I see the following issue > while executing single one query: > ERROR: could not resize shared > memory segment "/PostgreSQL.1596105766" to 536870912 bytes: No space left on > device > > In my postgresql.conf I set sharred_buffers=256MB, I see that it is applied: > SHOW shared_buffers; > shared_buffers > ---------------- > 256MB > > At the same time during the query execution, I see a lot of files in /dev/shm > with the total size more than 256MB > > ls -lh /dev/shm > > How can I configure limit for total shared memory size?
The limit is mostly set by the memory, as /dev/shm is like virtual memory or RAM disk. Increase the RAM. Jean
