Re: PGSQL 11.4: shared_buffers and /dev/shm size - Mailing list pgsql-general

From Jean Louis
Subject Re: PGSQL 11.4: shared_buffers and /dev/shm size
Date
Msg-id 20190709095344.GK7323@protected.rcdrun.com
Whole thread Raw
In response to PGSQL 11.4: shared_buffers and /dev/shm size  (Konstantin Malanchev <hombit@gmail.com>)
Responses Re: PGSQL 11.4: shared_buffers and /dev/shm size
List pgsql-general
* Konstantin Malanchev <hombit@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



pgsql-general by date:

Previous
From: Konstantin Malanchev
Date:
Subject: PGSQL 11.4: shared_buffers and /dev/shm size
Next
From: Konstantin Malanchev
Date:
Subject: Re: PGSQL 11.4: shared_buffers and /dev/shm size