vacuum on table with all rows frozen

Поиск
Список
Период
Сортировка
От Tom DalPozzo
Тема vacuum on table with all rows frozen
Дата
Msg-id CAK77FCTeB3EcPwJxxUk9R+5SbFqR-Ph5LNqexHfRim2x1kSY_w@mail.gmail.com
обсуждение исходный текст
Ответы Re: vacuum on table with all rows frozen  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi,
let's suppose I have a table which after beign populated with only INSERTs, doesn't receive no more writing queries (neither insert or update or delete). Only reading queries.
Once all table rows get frozen by (auto)vacuum, will a next (auto)vacuum scan that table for any reason or does it understand that it would be useless (as no more rows to mark as forzen and no dead tuples) ?
As I will have hunderds of big tables like that, I want to be sure that the vacuum process doesn't waste time.
Regards
Pupillo




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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Keycloak and Postgres
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: vacuum on table with all rows frozen