Re: MultiXactMemberFreezeThreshold can make autovacuum *less* aggressive

2024-06-13 Thread Heikki Linnakangas
On 13/06/2024 17:40, Robert Haas wrote: On Thu, Jun 13, 2024 at 8:29 AM Heikki Linnakangas 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,

Re: MultiXactMemberFreezeThreshold can make autovacuum *less* aggressive

2024-06-13 Thread Robert Haas
On Thu, Jun 13, 2024 at 8:29 AM Heikki Linnakangas 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

MultiXactMemberFreezeThreshold can make autovacuum *less* aggressive

2024-06-13 Thread Heikki Linnakangas
The purpose of MultiXactMemberFreezeThreshold() is to make the effective autovacuum_multixact_freeze_max_age smaller, if the multixact members SLRU is approaching wraparound. Per comment there: * To prevent that, if more than a threshold portion of the members space is * used, we effectively