weird negative seconds on checkpoint message.

From: "Ing(dot)Edmundo(dot)Robles(dot)Lopez" <erobles(at)sensacd(dot)com(dot)mx>
To: <pgsql-general(at)postgresql(dot)org>
Subject: weird negative seconds on checkpoint message.
Date: 2011-12-02 22:33:05
Message-ID: 4ED95221.8080601@sensacd.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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????
El contenido de este correo electrónico y sus archivos adjuntos son privados y confidenciales y va dirigido exclusivamente a su destinatario. No se autoriza la utilización, retransmisión, diseminación, o cualquier otro uso de esta información por un receptor o entidades distintas al destinatario. Si recibe este correo sin ser el destinatario se le solicita eliminarlo y hacerlo del conocimiento del emisor. La empresa no se hace responsable de transmisiones o comunicaciones no autorizadas o emitidas por personas ajenas a sus colaboradores utilizando éste medio electrónico.

The content of this email and its attached files are private and confidential and intended exclusively for the use of the individual or entity to which they are addressed. The retransmission, dissemination, or any other use of this information other than by the intended recipient is prohibited. If you have received this email in error please delete it and notify the sender. The company cannot be held liable for unauthorized electronic transmissions or communications, nor for those emitted by non-company individuals and entities.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ing.Edmundo.Robles.Lopez 2011-12-02 22:48:49 Re: weird negative seconds on checkpoint message.
Previous Message Jeff Amiel 2011-12-02 22:22:48 Re: Oddball data distribution giving me planner headaches