Re: Emit fewer vacuum records by reaping removable tuples during pruning

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Emit fewer vacuum records by reaping removable tuples during pruning
Дата
Msg-id ZYeT7YDwvgEkI6uS@paquier.xyz
обсуждение исходный текст
Ответ на Re: Emit fewer vacuum records by reaping removable tuples during pruning  (Melanie Plageman <melanieplageman@gmail.com>)
Ответы Re: Emit fewer vacuum records by reaping removable tuples during pruning  (Melanie Plageman <melanieplageman@gmail.com>)
Список pgsql-hackers
On Mon, Nov 13, 2023 at 07:06:15PM -0500, Melanie Plageman wrote:
> As best I can tell, our best case scenario is Thomas' streaming read API
> goes in, we add vacuum as a user, and we can likely remove the skip
> range logic.

This does not prevent the work you've been doing in 0001 and 0002
posted upthread, right?  Some progress is always better than no
progress, and I can see the appeal behind doing 0001 actually to keep
the updates of the block numbers closer to where we determine if
relation truncation is safe of not rather than use an intermediate
state in LVPagePruneState.

0002 is much, much, much trickier..
--
Michael

Вложения

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

Предыдущее
От: Morris de Oryx
Дата:
Сообщение: Re: Are operations on real values IMMUTABLE or STABLE?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: pgsql: Prevent tuples to be marked as dead in subtransactions on standb