Postgres Pro
Downloads
Home   >   mailing lists

Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples? - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples?
Date
Msg-id bfbfadf4884160615800df1b3bdb675797bbf997.camel@cybertec.at
Whole thread Raw
In response to Why is INSERT-driven autovacuuming based on pg_class.reltuples?  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Why is INSERT-driven autovacuuming based on pg_class.reltuples?
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Bharath Rupireddy
Date:
Subject: Report checkpoint progress with pg_stat_progress_checkpoint (was: Report checkpoint progress in server logs)
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: Suppressing useless wakeups in walreceiver