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/
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 |