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

Поиск
Список
Период
Сортировка
От Bossart, Nathan
Тема Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?
Дата
Msg-id 2F433CA6-FD9D-4D38-82BF-541FF48CA7A9@amazon.com
обсуждение исходный текст
Ответ на Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?  (SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com>)
Ответы Re: Do we need pre-allocate WAL files during end-of-recovery checkpoint?  (Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On 12/6/21, 4:54 AM, "Bharath Rupireddy" <bharath.rupireddyforpostgres@gmail.com> wrote:
> The function PreallocXlogFiles doesn't get called during
> end-of-recovery checkpoint in CreateCheckPoint, see [1]. The server
> becomes operational after the end-of-recovery checkpoint and may need
> WAL files. However, I'm not sure how beneficial it is going to be if
> the WAL is pre-allocated (as PreallocXlogFiles just allocates only 1
> extra WAL file).

There is another thread for adding more effective WAL pre-allocation
[0] that you might be interested in.

Nathan

[0] https://www.postgresql.org/message-id/flat/20201225200953.jjkrytlrzojbndh5%40alap3.anarazel.de

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

Предыдущее
От: "Bossart, Nathan"
Дата:
Сообщение: Re: Is it correct to update db state in control file as "shutting down" during end-of-recovery checkpoint?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Why doesn't pgstat_report_analyze() focus on not-all-visible-page dead tuple counts, specifically?