Re: [GENERAL] checkpoint_segments warning?

2008-05-05 Thread Martin Marques
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 t

Re: [GENERAL] checkpoint_segments warning?

2008-05-05 Thread Dan Armbrust
> > 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? > >

Re: [GENERAL] checkpoint_segments warning?

2008-05-05 Thread Tom Lane
"Dan Armbrust" <[EMAIL PROTECTED]> 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 calculat

[GENERAL] checkpoint_segments warning?

2008-05-05 Thread Dan Armbrust
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? Thanks, D