Re: Should vacuum process config file reload more often

Masahiko Sawada <sawada.mshk@gmail.com>

From: Masahiko Sawada <sawada.mshk@gmail.com>

To: Daniel Gustafsson <daniel@yesql.se>

Cc: Melanie Plageman <melanieplageman@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Andres Freund <andres@anarazel.de>, Tom Lane <tgl@sss.pgh.pa.us>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Amit Kapila <amit.kapila16@gmail.com>

Date: 2023-04-25T13:31:11Z

Lists: pgsql-hackers

On Tue, Apr 25, 2023 at 9:39 PM Daniel Gustafsson <daniel@yesql.se> wrote:
>
> > On 17 Apr 2023, at 04:04, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
> > I've attached an updated patch for fixing at_dobalance condition.
>
> I revisited this and pushed it to all supported branches after another round of
> testing and reading.

Thanks!

Can we mark the open item "Can't disable autovacuum cost delay through
storage parameter" as resolved?

Regards,

-- 
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

Commits

Fix assertion failure in heap_vacuum_rel
- 4a6603cd4650 16.0 landed
Fix vacuum_cost_delay check for balance calculation.
- cba3c8f6dd7f 12.15 landed
- bfac8f8bc4a4 16.0 landed
- b95f36f86131 13.11 landed
- 0e8e5e856cc3 14.8 landed
- 0319b306e87e 15.3 landed
- 0151d2c5f256 11.20 landed
Fix autovacuum cost debug logging
- a9781ae11ba2 16.0 landed
Refresh cost-based delay params more frequently in autovacuum
- 7d71d3dd080b 16.0 landed
Separate vacuum cost variables from GUCs
- a85c60a945ac 16.0 landed
Make vacuum failsafe_active globally visible
- 71a825194fd3 16.0 landed
Don't balance vacuum cost delay when per-table settings are in effect
- 1021bd6a89bc 9.5.0 cited