Thread: Tunning postgresql.conf

Hi all,

I have a server with 4 x Intel(R) Xeon(R) CPU E5640  @ 2.67GHz and * 12 GB*
of memory.
*

There will be hosted ~100 databases with lot of reads and some writing.

My postgresql.conf is:*


listen_addresses = '*'
max_connections = 300

shared_buffers = 3072MB

work_mem = 72MB
maintenance_work_mem = 704MB
synchronous_commit = off

wal_buffers = 8MB

checkpoint_segments = 16
checkpoint_completion_target = 0.9
effective_cache_size = 8GB

default_statistics_target = 50
constraint_exclusion = on



Is this good configuration?



Thanks




--
View this message in context: http://postgresql.1045698.n5.nabble.com/Tunning-postgresql-conf-tp5748633.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.