Checkpoint question
От | u15074 |
---|---|
Тема | Checkpoint question |
Дата | |
Msg-id | 1058769015.3f1b8877385be@webmail.hs-harz.de обсуждение исходный текст |
Ответы |
Re: Checkpoint question
|
Список | 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/
В списке pgsql-general по дате отправления: