Re: checkpoint_segments warning? - Mailing list pgsql-general

From Martin Marques
Subject Re: checkpoint_segments warning?
Date
Msg-id 481F89DC.5020706@marquesminen.com.ar
Whole thread Raw
In response to checkpoint_segments warning?  ("Dan Armbrust" <daniel.armbrust.list@gmail.com>)
List pgsql-general
Dan Armbrust escribió:
> I got a warning from PostgreSQL 8.3.1 that said something to the effect of
>
> checkpoints are happening to frequently... (-2484 seconds)
>
> That part that confused me was the "-2484".  Is that just a hyphen in
> a strange place?  Or did it really calculate a negative value?
>
> Is this expected?

Did you get a date change in the server between checkpoints? Check the
logs (if you are logging the time of the logs).

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Custom C function - is palloc broken?
Next
From: "Dan \"Heron\" Myers"
Date:
Subject: more custom C function fun