Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples?

Поиск
Список
Период
Сортировка
Искать
От
Laurenz Albe
Тема
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples?
Дата
Msg-id
bfbfadf4884160615800df1b3bdb675797bbf997.camel@cybertec.at
Ответ на
Список
Дерево обсуждения
Why is INSERT-driven autovacuuming based on pg_class.reltuples? Peter Geoghegan <pg@bowt.ie>
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples? Laurenz Albe <laurenz.albe@cybertec.at>
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples? Peter Geoghegan <pg@bowt.ie>
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples? David Rowley <dgrowleyml@gmail.com>
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples? David Rowley <dgrowleyml@gmail.com>
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples? Peter Geoghegan <pg@bowt.ie>
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples? Peter Geoghegan <pg@bowt.ie>
Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples? Justin Pryzby <pryzby@telsasoft.com>
On Thu, 2022-01-27 at 12:20 -0800, Peter Geoghegan wrote:
> I can see why the nearby, similar vacthresh and anlthresh variables
> (not shown here) are scaled based on pg_class.reltuples -- that makes
> sense. But why should we follow that example here, with vacinsthresh?

What would you suggest instead?  pg_stat_all_tables.n_live_tup?

Yours,
Laurenz Albe



В списке pgsql-hackers по дате отправления
От: Bharath Rupireddy
Дата:
От: Kyotaro Horiguchi
Дата:
FAQ