| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | "Ing(dot)Edmundo(dot)Robles(dot)Lopez" <erobles(at)sensacd(dot)com(dot)mx> |
| Subject: | Re: weird negative seconds on checkpoint message. |
| Date: | 2011-12-02 22:50:13 |
| Message-ID: | 201112021450.13883.adrian.klaver@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Friday, December 02, 2011 2:33:05 pm Ing.Edmundo.Robles.Lopez wrote:
> Hi!
> I have the next messege:
> LOG: checkpoints are occurring too frequently (-21093 seconds apart)
>
> Postgres 8.3.11 is running on SCO Openserver 5.0.7
>
> and this is my checkpoint configuration:
> # - Checkpoints -
>
> checkpoint_segments = 32 # in logfile segments, min 1, 16MB each
> checkpoint_timeout = 15min # range 30s-1h
> checkpoint_completion_target = 0.7 # checkpoint target duration, 0.0
> - 1.0
> #checkpoint_warning = 30s # 0 is off
>
>
> Any idea, why i get negative value????
Those pesky neutrinos going faster then the speed of light:)?
On a serious note, has anyone changed the time on the server recently?
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Amiel | 2011-12-02 23:11:42 | Re: Oddball data distribution giving me planner headaches |
| Previous Message | Ing.Edmundo.Robles.Lopez | 2011-12-02 22:48:49 | Re: weird negative seconds on checkpoint message. |