Commite7a6cd5

committed

doc: PG 13 relnotes: hash_mem_multiplier can restore old behav.

Document that hash_mem_multiplier can get query behavior closer to thepre-PG 13 behavior of allowing hashing to use more memory.Reported-by: Peter GeogheganDiscussion:https://postgr.es/m/CAH2-Wzn3kwQm_pe6g2=ki+P7+ZRqH5GvFGn6SWfv_j7UUgcLdQ@mail.gmail.comBackpatch-through: 13 only

1 parent72ca611 commite7a6cd5Copy full SHA for e7a6cd5

File tree

-1

lines changed

-1

lines changed

Lines changed: 4 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -649,7 +649,10 @@ Author: Jeff Davis <jdavis@postgresql.org>`
`649`	`649`
`650`	`650`	`<para>`
`651`	`651`	`Previously, hash aggregation was avoided if it was expected to use`
`652`		`- more than <xref linkend="guc-work-mem"/> memory.`
	`652`	`+ more than <xref linkend="guc-work-mem"/> memory. To reduce the`
	`653`	`+ likelihood of using disk storage for hash aggregation and attain`
	`654`	`+ behavior similar to previous Postgres releases, increase <xref`
	`655`	`+ linkend="guc-hash-mem-multiplier"/>.`
`653`	`656`	`</para>`
`654`	`657`	`</listitem>`
`655`	`658`

Comments

(0)