Commit888fa2b

committed

Skip allocating hash table in EXPLAIN-only mode.

This is a backpatch of commit2cccb62, backpatched due to populardemand. Backpatch to all supported versions.Author: Alexey BashtanovDiscussion:https://www.postgresql.org/message-id/36823f65-050d-ae24-aa4d-a37726998240%40imap.cc

1 parent5b83604 commit888fa2bCopy full SHA for 888fa2b

File tree

-1

lines changed

-1

lines changed

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -2488,7 +2488,11 @@ ExecInitAgg(Agg node, EState estate, int eflags)`
`2488`	`2488`	`aggstate->hash_pergroup=pergroups;`
`2489`	`2489`
`2490`	`2490`	`find_hash_columns(aggstate);`
`2491`		`-build_hash_table(aggstate);`
	`2491`	`+`
	`2492`	`+/* Skip massive memory allocation if we are just doing EXPLAIN */`
	`2493`	`+if (!(eflags&EXEC_FLAG_EXPLAIN_ONLY))`
	`2494`	`+build_hash_table(aggstate);`
	`2495`	`+`
`2492`	`2496`	`aggstate->table_filled= false;`
`2493`	`2497`	`}`
`2494`	`2498`

Comments

(0)