Checkpoint question

From: u15074 <u15074(at)hs-harz(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Checkpoint question
Date: 2003-07-21 06:30:15
Message-ID: 1058769015.3f1b8877385be@webmail.hs-harz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

To improve the performance of PostgreSQL, resp. to avoid too frequently occuring
checkpoints, it is recommended to increase the number of wal files
(checkpoint_segments).
So I increased the number of checkpoint segments to be able to write a lot of
data into the database without interruptions due to checkpoints.
My question now is concerning the cost of a checkpoint if I have a lot of
checkpoint segments. At checkpoint time will there be checkpointed all the
information contained in all log files, lets assume that I have 40 checkpoint
segments for example, or will only some informations of the log files be
checkpointed?
If all log files are checkpointed, won't this take a lot of time, and if so
wouldn't it be better to leave the number of checkoint segments to a smaller value?
I'm not quite familiar with the checkpoint concept, so maybe I'm wrong with my
thoughts. Can anyone give advice/explanations?

Thanks Andreas

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gordon Luk 2003-07-21 07:09:36 Error : ASP.NET with ODBC driver (Postgresql + Unicode beta driver (7.03.0100))
Previous Message Bruce Momjian 2003-07-21 04:48:43 Re: Dynamic plpgsql code