Postgres Pro
Downloads
Home   >   mailing lists

Re: Memory-Bounded Hash Aggregation - Mailing list pgsql-hackers

From Pengzhou Tang
Subject Re: Memory-Bounded Hash Aggregation
Date
Msg-id CAG4reAQ_852vigJ2cvaSQEQEstyOp5gPafS6pJrUKd4wzf_2Wg@mail.gmail.com
Whole thread Raw
In response to Re: Memory-Bounded Hash Aggregation  (Pengzhou Tang <ptang@pivotal.io>)
List pgsql-hackers
Tree view

On Fri, Mar 20, 2020 at 1:20 PM Pengzhou Tang <ptang@pivotal.io> wrote:
Hi,

I happen to notice that "set enable_sort to false" cannot guarantee the planner to use hashagg in test groupingsets.sql,
the following comparing results of sortagg and hashagg seems to have no meaning.


Please forget my comment, I should set enable_groupingsets_hash_disk too. 


pgsql-hackers by date:

Previous
From: Paul A Jungwirth
Date:
Subject: Re: range_agg
Next
From: Amit Kapila
Date:
Subject: Re: error context for vacuum to include block number