Re: Should vacuum process config file reload more often

Daniel Gustafsson <daniel@yesql.se>

From: Daniel Gustafsson <daniel@yesql.se>

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

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-25T12:39:39Z

Lists: pgsql-hackers

> 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.

--
Daniel Gustafsson

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