Re: Should vacuum process config file reload more often

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Daniel Gustafsson <daniel@yesql.se>

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

Date: 2023-04-05T19:42:33Z

Lists: pgsql-hackers

On Wed, Apr 5, 2023 at 3:04 PM Daniel Gustafsson <daniel@yesql.se> wrote:
> > Daniel: Are you intending to commit this?
>
> Yes, my plan is to get it in before feature freeze.

All right, let's make it happen! I think this is pretty close to ready
to ship, and it would solve a problem that is real, annoying, and
serious.

-- 
Robert Haas
EDB: http://www.enterprisedb.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