pgsql: Doc: correct aggressive vacuum threshold for multixact members s - Mailing list pgsql-committers

From John Naylor
Subject pgsql: Doc: correct aggressive vacuum threshold for multixact members s
Date
Msg-id E1tqOOu-001Bob-24@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Doc: correct aggressive vacuum threshold for multixact members storage

The threshold is two billion members, which was interpreted as 2GB
in the documentation. Fix to reflect that each member takes up five
bytes, which translates to about 10GB. This is not exact, because of
page boundaries. While at it, mention the maximum size 20GB.

This has been wrong since commit c552e171d16e, so backpatch to
version 14.

Author: Alex Friedman <alexf01@gmail.com>
Reviewed-by: Sami Imseih <samimseih@gmail.com>
Reviewed-by: Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Discussion: https://postgr.es/m/CACbFw60UOk6fCC02KsyT3OfU9Dnuq5roYxdw2aFisiN_p1L0bg@mail.gmail.com
Backpatch-through: 14

Branch
------
REL_17_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/5c8dcf9483349f39ee8da965c3acd3a61cf242fe

Modified Files
--------------
doc/src/sgml/maintenance.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Fix race condition in TAP test 007_pre_auth
Next
From: John Naylor
Date:
Subject: Re: pgsql: vacuumdb: Add option for analyzing only relations missing stats.