Proposal- GUC for max dead rows before autovacuum - Mailing list pgsql-hackers

From Michael Lewis
Subject Proposal- GUC for max dead rows before autovacuum
Date
Msg-id CAHOFxGqM1MeUv7aSKZo9MNXwNpa6SwXgRnzpLky3VzvJY3yixA@mail.gmail.com
Whole thread Raw
Responses Re: Proposal- GUC for max dead rows before autovacuum  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-hackers
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 means small tables are auto vacuumed rarely.

The default value for this new setting value could be -1 or 0 to disable the feature, or something like 100,000 perhaps so that tables with more than 500,0000 tuples are candidates for an autovacuum before they would with current default values.

pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Invisible PROMPT2
Next
From: Justin Pryzby
Date:
Subject: Re: checkpointer: PANIC: could not fsync file: No such file ordirectory