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