From: | Jean Louis <bugs(at)gnu(dot)support> |
---|---|
To: | Konstantin Malanchev <hombit(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PGSQL 11.4: shared_buffers and /dev/shm size |
Date: | 2019-07-09 09:53:44 |
Message-ID: | 20190709095344.GK7323@protected.rcdrun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
* Konstantin Malanchev <hombit(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Konstantin Malanchev | 2019-07-09 10:09:26 | Re: PGSQL 11.4: shared_buffers and /dev/shm size |
Previous Message | Konstantin Malanchev | 2019-07-09 09:50:31 | PGSQL 11.4: shared_buffers and /dev/shm size |