Commitda08ac5

committed

Doc: mention that VACUUM can't utilize over 1GB of RAM

Document that setting maintenance_work_mem to values over 1GB has noeffect on VACUUM.Reported-by: Martín MarquésAuthor: Laurenz AlbeDiscussion:https://postgr.es/m/CABeG9LsZ2ozUMcqtqWu_-GiFKB17ih3p8wBHXcpfnHqhCnsc7A%40mail.gmail.comBackpatch-through: 9.6, oldest supported release

1 parent27f6970 commitda08ac5Copy full SHA for da08ac5

File tree

-0

lines changed

-0

lines changed

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1617,6 +1617,12 @@ include_dir 'conf.d'`
`1617`	`1617`	`too high. It may be useful to control for this by separately`
`1618`	`1618`	`setting <xref linkend="guc-autovacuum-work-mem"/>.`
`1619`	`1619`	`</para>`
	`1620`	`+ <para>`
	`1621`	`+ Additionally, <command>VACUUM</command> is only able to utilize up to`
	`1622`	`+ a maximum of <literal>1GB</literal> of memory, so`
	`1623`	`+ <varname>maintenance_work_mem</varname> values higher than this have`
	`1624`	`+ no effect on <command>VACUUM</command>.`
	`1625`	`+ </para>`
`1620`	`1626`	`</listitem>`
`1621`	`1627`	`</varlistentry>`
`1622`	`1628`

Comments

(0)