Questions tagged [shared-buffers]
The shared-buffers tag has no usage guidance.
6
questions
1
vote
1
answer
17
views
pg_prewarm like funcationality in MySQL
I know in Postgres, we can explicitly load a table into the cache using pg_prewarm extension, is there a similar mechanism/UDF/etc in MySQL? I know MySQL would cache data in shared buffer implicitly, ...
- 11
2
votes
1
answer
58
views
Exclude tables from shared_buffers in postgres
Is there a way to exclude tables from being added to the shared_buffers?
I've looked at the space used by the tables and those which use the most are not really relevant for us at the moment. There ...
- 121
3
votes
2
answers
871
views
AWS Aurora PostgreSQL Serverless: How do you pre-warm the shared buffer after scaling?
I'm using AWS Aurora PostgreSQL Serverless with autoscaling.
It appears as though scaling clears the shared buffer, so right when we want to crank out the performance, we are forced to face-plant with ...
- 133
2
votes
3
answers
8k
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 ...
- 173
0
votes
1
answer
295
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 ...
- 25
1
vote
0
answers
1k
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/...
- 777