diff options
| author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2020-11-20 14:41:14 +0200 |
|---|---|---|
| committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2020-11-20 14:49:42 +0200 |
| commit | 1dbe627fd6bf889ad117a706ff474f7382a66465 (patch) | |
| tree | 623dfc29d4b369dad88e0704b8e1b2c555822f91 /src | |
| parent | 153bf8d2044a1bab07c151ae2b3c306c0b138161 (diff) | |
| download | postgresql-1dbe627fd6bf889ad117a706ff474f7382a66465.tar.gz postgresql-1dbe627fd6bf889ad117a706ff474f7382a66465.zip | |
Skip allocating hash table in EXPLAIN-only mode.
This is a backpatch of commit 2cccb627f1, backpatched due to popular
demand. Backpatch to all supported versions.
Author: Alexey Bashtanov
Discussion: https://www.postgresql.org/message-id/36823f65-050d-ae24-aa4d-a37726998240%40imap.cc
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/executor/nodeAgg.c | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/src/backend/executor/nodeAgg.c b/src/backend/executor/nodeAgg.c index 1dcd8e19ed2..8f9d588e5a5 100644 --- a/src/backend/executor/nodeAgg.c +++ b/src/backend/executor/nodeAgg.c @@ -3073,7 +3073,11 @@ ExecInitAgg(Agg *node, EState *estate, int eflags) aggstate->hash_pergroup = palloc0(sizeof(AggStatePerGroup) * numHashes); find_hash_columns(aggstate); - build_hash_table(aggstate); + + /* Skip massive memory allocation if we are just doing EXPLAIN */ + if (!(eflags & EXEC_FLAG_EXPLAIN_ONLY)) + build_hash_table(aggstate); + aggstate->table_filled = false; } |