Re: [BUG] Checkpointer on hot standby runs without looking checkpoint_segments
От | Kyotaro HORIGUCHI |
---|---|
Тема | Re: [BUG] Checkpointer on hot standby runs without looking checkpoint_segments |
Дата | |
Msg-id | CAM103DuTDF_3iqO9wXivcYPr7=dO8bs3rQhirWm_AKMCZdL97A@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: [BUG] Checkpointer on hot standby runs without looking checkpoint_segments (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>) |
Ответы |
Re: [BUG] Checkpointer on hot standby runs without looking checkpoint_segments
|
Список | pgsql-hackers |
Sorry, I've wrote something wrong. >> The reason we haven't historically obeyed checkpoint_segments >> during recovery is that it slows down the recovery >> unnecessarily if you're restoring from a backup and you replay, > > The variable StandbyMode is false on archive recovery, so no > checkpoint triggerred during then. Nevertheless, checkpoints will be triggered by checkpoint_timeout and run at the maybe higher speed governed by checkpoint_segments. This is undesirable behavior from such a point of view. But I think referring checkpoint_segment on such case should be inhibited, and I suppose it is possible using StandbyMode in IsCheckpointOnSchedule(), I suppose. I will correct the patch later. regards, -- Kyotaro Horiguchi NTT Open Source Software Center == My e-mail address has been changed since Apr. 1, 2012.
В списке pgsql-hackers по дате отправления: