Postgres Pro
Downloads
Home   >   mailing lists

Re: MultiXactMemberFreezeThreshold can make autovacuum *less* aggressive - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: MultiXactMemberFreezeThreshold can make autovacuum *less* aggressive
Date
Msg-id fdcc3def-c1cb-466f-88d3-d368c6e8be71@iki.fi
Whole thread Raw
In response to Re: MultiXactMemberFreezeThreshold can make autovacuum *less* aggressive  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Tree view 
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)

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: jsonpath: Missing Binary Execution Path?
Next
From: Ranier Vilela
Date:
Subject: Re: Improve the granularity of PQsocketPoll's timeout parameter?