From 7351bfeda33b60b69c15791c7eb77a127546df26 Mon Sep 17 00:00:00 2001 From: Jeff Davis Date: Sat, 28 Mar 2020 10:53:01 -0700 Subject: Fix costing for disk-based hash aggregation. Report and suggestions from Richard Guo and Tomas Vondra. Discussion: https://postgr.es/m/CAMbWs4_W8fYbAn8KxgidAaZHON_Oo08OYn9ze=7remJymLqo5g@mail.gmail.com --- src/backend/executor/nodeAgg.c | 2 ++ 1 file changed, 2 insertions(+) (limited to 'src/backend/executor/nodeAgg.c') diff --git a/src/backend/executor/nodeAgg.c b/src/backend/executor/nodeAgg.c index 2a6f44a6274..4c8c5cfc07a 100644 --- a/src/backend/executor/nodeAgg.c +++ b/src/backend/executor/nodeAgg.c @@ -1728,6 +1728,8 @@ hash_agg_set_limits(double hashentrysize, uint64 input_groups, int used_bits, /* if not expected to spill, use all of work_mem */ if (input_groups * hashentrysize < work_mem * 1024L) { + if (num_partitions != NULL) + *num_partitions = 0; *mem_limit = work_mem * 1024L; *ngroups_limit = *mem_limit / hashentrysize; return; -- cgit v1.2.3