Commitec34040

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 parent63b1af9 commitec34040Copy full SHA for ec34040

File tree

-0

lines changed

-0

lines changed

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1893,6 +1893,12 @@ include_dir 'conf.d'`
`1893`	`1893`	`too high. It may be useful to control for this by separately`
`1894`	`1894`	`setting <xref linkend="guc-autovacuum-work-mem"/>.`
`1895`	`1895`	`</para>`
	`1896`	`+ <para>`
	`1897`	`+ Additionally, <command>VACUUM</command> is only able to utilize up to`
	`1898`	`+ a maximum of <literal>1GB</literal> of memory, so`
	`1899`	`+ <varname>maintenance_work_mem</varname> values higher than this have`
	`1900`	`+ no effect on <command>VACUUM</command>.`
	`1901`	`+ </para>`
`1896`	`1902`	`</listitem>`
`1897`	`1903`	`</varlistentry>`
`1898`	`1904`

Comments

(0)