public inbox for [email protected]help / color / mirror / Atom feed
pgsql: Doc: correct aggressive vacuum threshold for multixact members s 5+ messages / 1 participants [nested] [flat]
* pgsql: Doc: correct aggressive vacuum threshold for multixact members s @ 2025-03-07 03:29 John Naylor <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: John Naylor @ 2025-03-07 03:29 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Sami Imseih <[email protected]> Reviewed-by: Bertrand Drouvot <[email protected]> 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(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Doc: correct aggressive vacuum threshold for multixact members s @ 2025-03-07 03:29 John Naylor <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: John Naylor @ 2025-03-07 03:29 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Sami Imseih <[email protected]> Reviewed-by: Bertrand Drouvot <[email protected]> Discussion: https://postgr.es/m/CACbFw60UOk6fCC02KsyT3OfU9Dnuq5roYxdw2aFisiN_p1L0bg@mail.gmail.com Backpatch-through: 14 Branch ------ REL_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/bc6a81ac3a8346c9f3cb5fc6f714977127aa2f31 Modified Files -------------- doc/src/sgml/maintenance.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Doc: correct aggressive vacuum threshold for multixact members s @ 2025-03-07 03:29 John Naylor <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: John Naylor @ 2025-03-07 03:29 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Sami Imseih <[email protected]> Reviewed-by: Bertrand Drouvot <[email protected]> Discussion: https://postgr.es/m/CACbFw60UOk6fCC02KsyT3OfU9Dnuq5roYxdw2aFisiN_p1L0bg@mail.gmail.com Backpatch-through: 14 Branch ------ REL_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/be342766fb02b55d91166386affa8607b1da842e Modified Files -------------- doc/src/sgml/maintenance.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Doc: correct aggressive vacuum threshold for multixact members s @ 2025-03-07 03:29 John Naylor <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: John Naylor @ 2025-03-07 03:29 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Sami Imseih <[email protected]> Reviewed-by: Bertrand Drouvot <[email protected]> Discussion: https://postgr.es/m/CACbFw60UOk6fCC02KsyT3OfU9Dnuq5roYxdw2aFisiN_p1L0bg@mail.gmail.com Backpatch-through: 14 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/fcabc3adf889ebf2c2d8d1c084989f5fd95aac2f Modified Files -------------- doc/src/sgml/maintenance.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: Doc: correct aggressive vacuum threshold for multixact members s @ 2025-03-07 03:29 John Naylor <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: John Naylor @ 2025-03-07 03:29 UTC (permalink / raw) To: [email protected] 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 <[email protected]> Reviewed-by: Sami Imseih <[email protected]> Reviewed-by: Bertrand Drouvot <[email protected]> Discussion: https://postgr.es/m/CACbFw60UOk6fCC02KsyT3OfU9Dnuq5roYxdw2aFisiN_p1L0bg@mail.gmail.com Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/98aa99b6d68293b500ad3a1042dfa22dd2e96918 Modified Files -------------- doc/src/sgml/maintenance.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2025-03-07 03:29 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-03-07 03:29 pgsql: Doc: correct aggressive vacuum threshold for multixact members s John Naylor <[email protected]> 2025-03-07 03:29 pgsql: Doc: correct aggressive vacuum threshold for multixact members s John Naylor <[email protected]> 2025-03-07 03:29 pgsql: Doc: correct aggressive vacuum threshold for multixact members s John Naylor <[email protected]> 2025-03-07 03:29 pgsql: Doc: correct aggressive vacuum threshold for multixact members s John Naylor <[email protected]> 2025-03-07 03:29 pgsql: Doc: correct aggressive vacuum threshold for multixact members s John Naylor <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox