Commit409d939

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 parent650e635 commit409d939Copy full SHA for 409d939

File tree

-0

lines changed

-0

lines changed

Lines changed: 6 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1769,6 +1769,12 @@ include_dir 'conf.d'`
`1769`	`1769`	`too high. It may be useful to control for this by separately`
`1770`	`1770`	`setting <xref linkend="guc-autovacuum-work-mem"/>.`
`1771`	`1771`	`</para>`
	`1772`	`+ <para>`
	`1773`	`+ Additionally, <command>VACUUM</command> is only able to utilize up to`
	`1774`	`+ a maximum of <literal>1GB</literal> of memory, so`
	`1775`	`+ <varname>maintenance_work_mem</varname> values higher than this have`
	`1776`	`+ no effect on <command>VACUUM</command>.`
	`1777`	`+ </para>`
`1772`	`1778`	`</listitem>`
`1773`	`1779`	`</varlistentry>`
`1774`	`1780`

Comments

(0)