We have a transactional D.B writing directly to postgres (8.3) and these parameters have worked ok for us checkpoint_timeout = 5min checkpoint_segments = 10 wal_buffers = 1024kB Date: Wed, 8 Oct 2008 12:34:00 -0200 From: rafael.domiciano@xxxxxxxxx To: bnichols@xxxxxxxxxxxxxxx Subject: Re: [ADMIN] checkpoint_timeout CC: chirag.dave@xxxxxxxxx; pgsql-admin@xxxxxxxxxxxxxx Hello Brad, #bgwriter_delay = 200ms # 10-10000ms between rounds #bgwriter_lru_percent = 1.0 # 0-100% of LRU buffers scanned/round
#bgwriter_lru_maxpages = 5 # 0-1000 buffers max written/round #bgwriter_all_percent = 0.333 # 0-100% of all buffers scanned/round #bgwriter_all_maxpages = 5 # 0-1000 buffers max written/round
I am trying now to increase the checkpoint_segments to 40... 2008/10/8 Brad Nicholson <bnichols@xxxxxxxxxxxxxxx>
|