Re: checkpoint_segments warning?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
Cc: "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: checkpoint_segments warning?
Date: 2008-05-05 19:41:28
Message-ID: 2622.1210016488@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Armbrust 2008-05-05 19:45:19 Re: checkpoint_segments warning?
Previous Message Daniel Schuchardt 2008-05-05 19:36:51 Re: operator is not unique: integer || integer