Re: Proposal- GUC for max dead rows before autovacuum

On Tue, 2019-11-19 at 15:35 -0700, Michael Lewis wrote: > To mitigate the need for per-table tuning of autovacuum configuration, I'd > like to propose a new GUC for autovacuum_vacuum_threshold_max. > > Currently, it seems that I can either set autovacuum_vacuum_scale_factor much > smaller than d

Proposal- GUC for max dead rows before autovacuum

To mitigate the need for per-table tuning of autovacuum configuration, I'd like to propose a new GUC for autovacuum_vacuum_threshold_max. Currently, it seems that I can either set autovacuum_vacuum_scale_factor much smaller than default on tables with millions of rows, or set a value globally that