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
You haven't configured shared_buffers at all? I would suggest setting it to 2GB
or such.
Andres
