On 02/28/11 17:56, Andres Freund wrote:
Hi,
On Saturday, February 26, 2011 12:11:19 AM Gary Fu wrote:
wal_buffers = 16MB
sensible
checkpoint_segments = 256
A setting that high seems unlikely to be beneficial... I suggest you configure
log_checkpoints to monitor this.
effective_cache_size = 30GB
Not likely to matter in this case.
maintenance_work_mem = 2GB
1GB is the max value taking effect.
I would also suggest setting
wal_sync_method=fdatasync
Already set this.
You haven't configured shared_buffers at all? I would suggest setting it to 2GB
or such.
It is set to 12GB.
Do you recommend to set fsync to off ? It needs to restart the server.
Thanks,
Gary
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
