From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Michael Lewis <mlewis(at)entrata(dot)com>, PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Proposal- GUC for max dead rows before autovacuum |
Date: | 2019-11-19 23:01:42 |
Message-ID: | 18258850a7cd0b61f3aec3654ecde6632d4db311.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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 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.
I think this is unnecessary.
Usually you have problems only with a few tables, and it is no problem
to set autovacuum parameters on these individually.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2019-11-19 23:05:11 | Re: Role membership and DROP |
Previous Message | Justin Pryzby | 2019-11-19 22:49:10 | Re: checkpointer: PANIC: could not fsync file: No such file or directory |