]> 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:25:02 +0000 (10:25 +0700)
commitbc6a81ac3a8346c9f3cb5fc6f714977127aa2f31
tree8c97bcbf9fad83a9761b7f3f702a7c24476ef7da
parent2d313375c092d5bbe67539bfa3c1630808339f89
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