Re: pg15b3: recovery fails with wal prefetch enabled

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: pg15b3: recovery fails with wal prefetch enabled
Дата
Msg-id CA+hUKGLYYaXWQfoEgPLsQ-6DwpEUZzbh6g_xhfF+yN=jTHC1mw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg15b3: recovery fails with wal prefetch enabled  (Thomas Munro <thomas.munro@gmail.com>)
Ответы Re: pg15b3: recovery fails with wal prefetch enabled  (Thomas Munro <thomas.munro@gmail.com>)
Список pgsql-hackers
On Thu, Sep 1, 2022 at 11:18 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> Ahh, problem repro'd here with WAL compression.  More soon.

I followed some false pistes for a while there, but I finally figured
it out what's happening here after Justin kindly shared some files
with me.  The active ingredient here is a setting of
maintenance_io_concurency=0, which runs into a dumb accounting problem
of the fencepost variety and incorrectly concludes it's reached the
end early.  Setting it to 3 or higher allows his system to complete
recovery.  I'm working on a fix ASAP.



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Perform streaming logical transactions by background workers and parallel apply
Следующее
От: "Drouvot, Bertrand"
Дата:
Сообщение: Re: Add tracking of backend memory allocated to pg_stat_activity