From: | Michael Lewis <mlewis(at)entrata(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Proposal- GUC for max dead rows before autovacuum |
Date: | 2019-11-19 22:35:50 |
Message-ID: | CAHOFxGqM1MeUv7aSKZo9MNXwNpa6SwXgRnzpLky3VzvJY3yixA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Pryzby | 2019-11-19 22:49:10 | Re: checkpointer: PANIC: could not fsync file: No such file or directory |
Previous Message | David Fetter | 2019-11-19 21:37:26 | Re: Invisible PROMPT2 |