Thanks Heikki ! Regards, VB
On Tue, Oct 4, 2011 at 4:38 PM, Heikki Linnakangas < heikki.linnakan...@enterprisedb.com> wrote: > On 04.10.2011 13:50, Venkat Balaji wrote: > >> I have got a situation where in i see the production system is loaded with >> the checkpoints and at-least 1000+ buffers are being written for every >> checkpoint. >> > > 1000 buffers isn't very much, that's only 8 MB, so that's not alarming > itself. > > > I am thinking of increasing the checkpoint_segments. >> >> Below are our current settings - >> >> checkpoint_segments = 8 >> checkpoint_timeout = 5 mins >> checkpoint_completion_target = 0.5 >> bgwriter_delay = 200ms >> bgwriter_lru_maxpages = 100 >> bgwriter_lru_multiplier = 2 >> >> Looking forward for suggestions. >> > > Yep, increase checkpoint_segments. And you probably want to raise > checkpoint_timeout too. > > -- > Heikki Linnakangas > EnterpriseDB http://www.enterprisedb.com >