Luke Lonergan wrote: > Chris, > > On 4/5/06 2:31 PM, "Chris Mair" <list@xxxxxxxx> wrote: > > > Doing what http://blogs.sun.com/roller/page/jkshah suggests: > > wal_sync_method = fsync (unchanged) > > wal_buffers = 128 (was 8) > > checkpoint_segments = 128 (was 3) > > bgwriter_all_percent = 0 (was 0.333) > > bgwriter_all_maxpages = 0 (was 5) > > and leaving everything else default (solarispackages from pgfoundry) > > increased performance ~ 7 times! > > In the recent past, Jignesh Shaw of Sun MDE discovered that changing the > bgwriter_* parameters to zero had a dramatic positive impact on performance. This essentially means stopping all bgwriter activity, thereby deferring all I/O until checkpoint. Was this considered? With checkpoint_segments to 128, it wouldn't surprise me that there wasn't any checkpoint executed at all during the whole test ... -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
