Re: checkpoint_segments warning?

"Dan Armbrust" <daniel.armbrust.list@gmail.com> writes:
> 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?

Yeah, it really did.  AFAICS this could only happen if the value of time(2)
went backwards.  Something fooling with your system clock?

            regards, tom lane