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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
