]> 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:26 +0000 (10:25 +0700)
commitbe342766fb02b55d91166386affa8607b1da842e
tree6440bdeffc95d676f1637697e6366785483337c8
parente2a6934a8855bc4c8421412bc4d9495de0753ab5
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