Re: checkpoint_segments warning?

From: Martin Marques <martin(at)marquesminen(dot)com(dot)ar>
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 22:27:40
Message-ID: 481F89DC.5020706@marquesminen.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan "Heron" Myers 2008-05-05 22:57:08 Re: Custom C function - is palloc broken?
Previous Message Hans Zaunere 2008-05-05 20:14:08 Re: COPY Performance