Horton

Re: MultiXactMemberFreezeThreshold can make autovacuum *less* aggressive

Heikki Linnakangas <hlinnaka@iki.fi>

View thread View on postgr.es
From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2024-06-13T16:04:19Z
Lists: pgsql-hackers 
On 13/06/2024 17:40, Robert Haas wrote:
> On Thu, Jun 13, 2024 at 8:29 AM Heikki Linnakangas <hlinnaka@iki.fi> wrote:
>> However, the value that the function calculates can sometimes be
>> *greater* than autovacuum_multixact_freeze_max_age.
> 
> That was definitely not what I intended and is definitely bad.
> 
>> In any case, I think the function
>> should clamp the result to autovacuum_multixact_freeze_max_age, per
>> attached.
> 
> LGTM.

Committed and backpatched to all supported versions. Thanks!

-- 
Heikki Linnakangas
Neon (https://neon.tech)

Commits

  1. Clamp result of MultiXactMemberFreezeThreshold