Re: n_ins_since_vacuum stats for aborted transactions

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: n_ins_since_vacuum stats for aborted transactions
Дата
Msg-id CAKFQuwb02TUjJXBRqkm8d=wA8uysttAPfTkUfDzr6uLUSVifZg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: n_ins_since_vacuum stats for aborted transactions  (Sami Imseih <samimseih@gmail.com>)
Список pgsql-hackers
On Wednesday, April 9, 2025, Sami Imseih <samimseih@gmail.com> wrote:

In other words, the reason n_ins_since_vacuum was introduced is to freeze
(committed) rows, so it should not need to track dead rows to do what it intends
to do.

n_ins_since_vacuum was introduced to indicate how many tuples a vacuum would touch on an insert-only table should vacuum be run now.  Autovacuum uses this value when determining whether a given relation should be vacuumed.

David J.

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