checkpoint segments

From: Havasvölgyi Ottó <h(dot)otto(at)freemail(dot)hu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: checkpoint segments
Date: 2005-07-09 22:37:29
Message-ID: 007101c584d6$ca1dde30$ba00a8c0@OTTO
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a small database on my Windows XP, I rarely use it. Even so, the log
file show says this:

[2005-07-02 02:02:09] LOG: received fast shutdown request

[2005-07-02 02:02:09] LOG: checkpoints are occurring too frequently (0
seconds apart)

[2005-07-02 02:02:09] HINT: Consider increasing the configuration
parameter "checkpoint_segments".

[2005-07-02 02:02:09] LOG: shutting down

[2005-07-02 02:02:10] LOG: database system is shut down

[2005-07-02 02:02:13] LOG: logger shutting down

My checkpoint_segments setting is default, 3, and there are 2 wal log files.
Why does it say, that "too frequenty"?
In fact what are checkpoints? These files? I couldn't understand it exactly
from the docs.

Thanks,
Otto

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Havasvölgyi Ottó 2005-07-09 22:56:25 Re: checkpoint segments
Previous Message Tom Lane 2005-07-09 15:30:44 Re: Transaction isolation levels