Re: MultiXactMemberFreezeThreshold can make autovacuum *less* aggressive

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: MultiXactMemberFreezeThreshold can make autovacuum *less* aggressive
Date: 2024-06-13 14:40:20
Message-ID: CA+TgmoYs_hYC-0ZACi1mBLqEB__-rWQ9jZ-APwL4huetvnT57A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 13, 2024 at 8:29 AM Heikki Linnakangas <hlinnaka(at)iki(dot)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.

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2024-06-13 14:49:34 Re: Avoid orphaned objects dependencies, take 3
Previous Message Peter Eisentraut 2024-06-13 14:01:23 Re: Contributing test cases to improve coverage