| Lists: | pgsql-general |
|---|
| From: | "Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)com> |
|---|---|
| To: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | checkpoint_segments warning? |
| Date: | 2008-05-05 19:28:47 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-general |
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,
Dan
| 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: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From: | "Dan Armbrust" <daniel(dot)armbrust(dot)list(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: checkpoint_segments warning? |
| Date: | 2008-05-05 19:45:19 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-general |
> > 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
>
Or _someone_. Yes. Precisely. I may even know who did it ;)
Thanks,
Dan
| 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: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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).