Postgres Pro
Downloads
Home   >   mailing lists

Re: checkpoint_segments warning? - Mailing list pgsql-general

From Tom Lane
Subject Re: checkpoint_segments warning?
Date
Msg-id 2622.1210016488@sss.pgh.pa.us
Whole thread Raw
In response to checkpoint_segments warning?  ("Dan Armbrust" <daniel.armbrust.list@gmail.com>)
Responses Re: checkpoint_segments warning?  ("Dan Armbrust" <daniel.armbrust.list@gmail.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Daniel Schuchardt
Date:
Subject: Re: operator is not unique: integer || integer
Next
From: "Dan Armbrust"
Date:
Subject: Re: checkpoint_segments warning?