| From: | Alex Friedman <alexf01(at)gmail(dot)com> |
|---|---|
| To: | Sami Imseih <samimseih(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Doc fix of aggressive vacuum threshold for multixact members storage |
| Date: | 2025-02-04 16:48:09 |
| Message-ID: | f0dd134b-97dc-4887-b9b0-2177c54aee39@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> A few paragraphs up the docs, there is this mention:
>
> ". There is a separate storage area which holds the list of members
> in each multixact, which also uses a 32-bit counter and which must
> also be managed."
>
> Maybe we can add more to this paragraph, such as:
>
> "also be managed. This member can grow to 20GB"
>
> And then in the proposed correction:
>
> "
> Also, if the storage occupied by multixacts members area exceeds 10GB
> (50% of the maximum the members area can grow), aggressive vacuum
> scans will occur more often for all tables
> "
>
> What do you think?
>
Looks good to me, attached a v2 patch with small adjustments.
Thanks,
Alex
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Doc-fix-of-aggressive-vacuum-threshold-for-multix.patch | text/plain | 1.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Gustafsson | 2025-02-04 16:51:28 | Re: add missing PQfinish() calls to vacuumdb |
| Previous Message | Guillaume Lelarge | 2025-02-04 16:46:01 | Re: Add a warning message when using unencrypted passwords |