diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 3eefe3811a..30bca45657 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1894,10 +1894,9 @@ include_dir 'conf.d' setting . - Additionally, VACUUM is only able to utilize up to - a maximum of 1GB of memory, so - maintenance_work_mem values higher than this have - no effect on VACUUM. + Note that for the collection of dead tuple identifiers, + VACUUM is only able to utilize up to a maximum of + 1GB of memory. @@ -1921,6 +1920,14 @@ include_dir 'conf.d' postgresql.conf file or on the server command line. + + For the collection of dead tuple identifiers, + autovacuum is only able to utilize up to a maximum of + 1GB of memory, so setting + autovacuum_work_mem to a value higher than that has + no effect on the number of dead tuples that autovacuum can collect + while scanning a table. +