Commit340ae3c

committed

Skip allocating hash table in EXPLAIN-only mode.

This is a backpatch of commit 2cccb627f1, 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 parent9e9a31b commit340ae3cCopy full SHA for 340ae3c

File tree

-1

lines changed

-1

lines changed

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3665,7 +3665,11 @@ ExecInitAgg(Agg node, EState estate, int eflags)`
`3665`	`3665`	`&aggstate->hash_ngroups_limit,`
`3666`	`3666`	`&aggstate->hash_planned_partitions);`
`3667`	`3667`	`find_hash_columns(aggstate);`
`3668`		`-build_hash_tables(aggstate);`
	`3668`	`+`
	`3669`	`+/* Skip massive memory allocation if we are just doing EXPLAIN */`
	`3670`	`+if (!(eflags&EXEC_FLAG_EXPLAIN_ONLY))`
	`3671`	`+build_hash_tables(aggstate);`
	`3672`	`+`
`3669`	`3673`	`aggstate->table_filled= false;`
`3670`	`3674`
`3671`	`3675`	`/* Initialize this to 1, meaning nothing spilled, yet */`

Comments

(0)