Re: Doc fix of aggressive vacuum threshold for multixact members storage

From: Sami Imseih <samimseih(at)gmail(dot)com>
To: Alex Friedman <alexf01(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 19:23:28
Message-ID: CAA5RZ0u7+_+KZUYEJmUOPd_Gtt4e90ecHxHPBLottJZBuk40Ng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I confirmed the 20GB value as is described here [1].
8k page can hold 409 member groups and each
member group can hold 4 members, thus
(2^32/(409 *4))*8192 = 20GB.

I also fixed whitespace issues in v3.

This is ready-for-committer In my opinion.

Regards,

Sami

[1] https://github.com/postgres/postgres/blob/HEAD/src/backend/access/transam/multixact.c#L131-L137

Attachment Content-Type Size
v3-0001-Doc-fix-of-aggressive-vacuum-threshold-for-multix.patch application/octet-stream 1.8 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Nathan Bossart 2025-02-04 19:30:38 Re: add missing PQfinish() calls to vacuumdb
Previous Message Álvaro Herrera 2025-02-04 19:03:21 Re: Better title output for psql \dt \di etc. commands