Aggressive vacuum frequency on a table

Поиск
Список
Период
Сортировка
От Simon Elbaz
Тема Aggressive vacuum frequency on a table
Дата
Msg-id CAPOUM=dDvfS02Ds-St+Arjm-ObJ2YhW6OS7yRZ++XKWGESJnSw@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
Hi list,


The maximum time that a table can go unvacuumed is two billion transactions minus the vacuum_freeze_min_age value at the time of the last aggressive vacuum.

...

This implies that if a table is not otherwise vacuumed, autovacuum will be invoked on it approximately once every autovacuum_freeze_max_age minus vacuum_freeze_min_age transactions.

From what I have understood, a table is eligible for aggressive vacuum when it reaches vacuum_freeze_table_age.

Then each table row becomes eligible when it reaches vacuum_freeze_min_age.

The autovacuum frequency would be then autovacuum_freeze_max_age minus vacuum_freeze_table_age transactions (and not autovacuum_freeze_max_age minus vacuum_freeze_min_age transactions).

Thanks for any answer
Regards

Simon


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

Предыдущее
От: Mikhail Balayan
Дата:
Сообщение: Automatic aggressive vacuum on almost frozen table takes too long
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Multi-column index: Which column order