Re: Doc fix of aggressive vacuum threshold for multixact members storage - Mailing list pgsql-hackers

From Alex Friedman
Subject Re: Doc fix of aggressive vacuum threshold for multixact members storage
Date
Msg-id 695cfd63-f766-4530-9b2a-34c1eae21ab7@gmail.com
Whole thread Raw
In response to Re: Doc fix of aggressive vacuum threshold for multixact members storage  (John Naylor <johncnaylorls@gmail.com>)
List pgsql-hackers
Hi John,

Thanks for reviewing.

> It seems at a minimum this one-line patch is sufficient for the correction:
> 
> -     storage occupied by multixacts members exceeds 2GB, aggressive vacuum
> +     storage occupied by multixacts members exceeds about 10GB,
> aggressive vacuum
> 
> Commit c552e171d16e removed the percentage as part of a judgment call
> on clarity, and I'm not sure that was wrong.
> 
> We could add the proposed language on "can grow up to about 20GB" at
> the end of this paragraph, which seems more natural -- first mention
> the amount that triggers aggressive vacuum, then the maximum size.

Yes, I believe this can work.


> I'm on the fence about putting a hint in the C file, but the
> computation has changed in the past, see commit b4d4ce1d50bbdf , so
> it's a reasonable idea.

That's a good find about the change. Taken together with Bertrand's comments, I've added two reminders to multixact.c
toupdate the docs, one for the threshold and another for the multixact storage scheme. Please see if it makes sense.
 

v4 patch attached.


Best regards,

Alex Friedman

Attachment

pgsql-hackers by date:

Previous
From: Corey Huinker
Date:
Subject: Re: Statistics Import and Export
Next
From: Bertrand Drouvot
Date:
Subject: Re: Draft for basic NUMA observability