Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans
Дата
Msg-id CAH2-WzkTrivGxWXLM0fBa9RTTdTmxUhPE+sXoAMgeagmNKLjtA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: Reducing the WAL overhead of freezing in VACUUM by deduplicating per-tuple freeze plans  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
On Thu, Nov 10, 2022 at 7:00 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
> Note that this comment is dangling in your patch:

Attached is v4, which removes the old comments you pointed out were
now out of place (they weren't adding much anyway). Also fixed bitrot
against HEAD from today's visibility map commit from Jeff Davis.

There is a more substantive change here, too. Like v3, v4 refactors
the *mechanical* details of how the XID based cutoff is handed down.
However, unlike v3, v4 goes back to using vacuumlazy.c's FreezeLimit
as the starting point for generating a latestRemovedXid. It seemed
better to deal with the recovery conflict issues created by my big
page-level freezing/freezing strategy patch set in the patch set
itself.

Will commit this early next week barring any objections.

Thanks
--
Peter Geoghegan

Вложения

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Add LSN along with offset to error messages reported for WAL file read/write/validate header failures
Следующее
От: "Imseih (AWS), Sami"
Дата:
Сообщение: Re: Add index scan progress to pg_stat_progress_vacuum