]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Doc: correct aggressive vacuum threshold for multixact members storage
authorJohn Naylor <john.naylor@postgresql.org>
Fri, 7 Mar 2025 03:22:56 +0000 (10:22 +0700)
committerJohn Naylor <john.naylor@postgresql.org>
Fri, 7 Mar 2025 03:24:38 +0000 (10:24 +0700)
commit98aa99b6d68293b500ad3a1042dfa22dd2e96918
treef713b3351ecbb5730d35d4384a5c1c6d2f1685ea
parentd52221cf0de411613ab7e0fe8b44e30cef64f1aa
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
doc/src/sgml/maintenance.sgml