| 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: | Whole Thread | Raw Message | 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 |