config file question between versions 7.4 - 9.1
Hello,
in the config file for 7.4 we have an entry:
shared_buffers = 1000 # min 16, at least max_connections*2, 8KB each
in 9.1 the default is:
shared_buffers = 32MB
max connections is the default 100
Do I need to make any adjustments or can I leave it at the default?
The machine is dedicated to Postgres and has 8GB of memory and a default
install of 9.1 and 7.4 doesn't appear to have any custom configuration.
Thanks!
Randy
Randy Johnson wrote:
in the config file for 7.4 we have an entry:
shared_buffers = 1000 # min 16, at least max_connections*2, 8KB each
in 9.1 the default is:
shared_buffers = 32MB
max connections is the default 100
Do I need to make any adjustments or can I leave it at the default?
The machine is dedicated to Postgres and has 8GB of memory and a
default install of 9.1 and 7.4
doesn't appear to have any custom configuration.
Read the documentation at
http://www.postgresql.org/docs/current/static/runtime-config-resource.ht
ml#GUC-SHARED-BUFFERS
I'd set it to something between 500MB and 2GB.
You can use the pg_buffercache contrib module to check how
the buffer cache is used and adjust accordingly.
Yours,
Laurenz Albe