Questions tagged [shared-buffers]
The shared-buffers tag has no usage guidance.
3
questions
1
vote
2answers
1k views
Postgres 10 Query waits on IO: BufFileWrite causing failure to get new database connections
I have a query (attached with query plan) that is run every 5-7 seconds from every device that is running our dashboard (typically, 500+ devices at peak time). This query, at the outset looks like it ...
0
votes
1answer
153 views
PostgreSQL. Shared_memory and sessions
I have a standalone server which is running Jira and PostgreSQL 9.6. I have noticed that PostgreSQL has shared_buffers parameter is equal 128MB where RAM is 32GB. Because server is shared with ...
1
vote
0answers
581 views
Why is PostgreSQL reporting a higher shared_buffers value than the parameter in the configuaration file when trying to enable huge_pages?
On a 7.5 GB host (Ubuntu 16.04.5 LTS), I have allocated 3 GB to shared_buffers:
postgres=# SHOW shared_buffers;
shared_buffers
----------------
3GB
(1 row)
with:
postgres@my-host:~$ cat /etc/...
