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)
Список
Дерево обсуждения
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
Дата: