Re: Checkpoints are occurring too frequently...

On Tue, 2005-07-12 at 13:29, Greg Patnude wrote:
> "Scott Marlowe" <smarlowe@g2switchworks.com> wrote in message
> news:1121191522.8208.231.camel@state.g2switchworks.com...
> > On Tue, 2005-07-12 at 13:04, Greg Patnude wrote:
> >> LOG:  checkpoints are occurring too frequently (19 seconds apart)
> >> HINT:  Consider increasing the configuration parameter
> >> "checkpoint_segments".
> >> LOG:  checkpoints are occurring too frequently (12 seconds apart)
> >> HINT:  Consider increasing the configuration parameter
> >> "checkpoint_segments".
> >> LOG:  checkpoints are occurring too frequently (12 seconds apart)
> >> HINT:  Consider increasing the configuration parameter
> >> "checkpoint_segments".
> >> LOG:  checkpoints are occurring too frequently (11 seconds apart)
> >> HINT:  Consider increasing the configuration parameter
> >> "checkpoint_segments".
> >> LOG:  checkpoints are occurring too frequently (12 seconds apart)
> >> HINT:  Consider increasing the configuration parameter
> >> "checkpoint_segments".
> >>
> >> What does this mean and what causes it ???
> >
> > Lots of updates or inserts.
> >
> > What are you doing with your database?  Are you running some application
> > that is doing a lot of small inserts maybe?
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: explain analyze is your friend
> >
> Sort of...  I have a stored procedure that gets called and updates either 50
> or 75 records in a table. The parent table has an inherited table (history)
> derived from it with an update rule on the parent table that inserts a copy
> of the unchanged record (prior to the update) into the history table. So --
> for every 50 updates -- I expect to see 50 inserts into the child.

So, how often is this running?  Once a second, once a minute, once and
hour?  If it's only running once an hour, then something else is wrong.