Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?

Поиск
Список
Период
Сортировка
От Bharath Rupireddy
Тема Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?
Дата
Msg-id CALj2ACWWGUnq1oYcTVF7NNUCFEn7Osnnza1dz789U6E8bmoqYA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?  (SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>)
Список pgsql-hackers
On Tue, Dec 7, 2021 at 12:35 AM SATYANARAYANA NARLAPURAM
<satyanarlapuram@gmail.com> wrote:
>
> If the segment size is 16MB it shouldn't take much time but higher segment values this can be a problem. But again,
thecurrent segment has to be filled 75% to precreate new one. I am not sure how much we gain. Do you have some numbers
withdifferent segment sizes? 

I don't have the numbers. However I agree that the pre-allocation can
make end-of-recovery checkpoint times more. At times, the
end-of-recovery checkpoint itself will take a good amount of time and
adding to it the pre-allocation of WAL time doesn't make sense.

Regards,
Bharath Rupireddy.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: Pre-allocating WAL files