Re: [HACKERS] to-do item for explain analyze of hash aggregates? - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: [HACKERS] to-do item for explain analyze of hash aggregates?
Date
Msg-id 7c8e81d0-3c68-03c4-28f9-f229c1fbeb6f@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] to-do item for explain analyze of hash aggregates?  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
On 04/24/2017 10:55 PM, Jeff Janes wrote:
> On Mon, Apr 24, 2017 at 12:13 PM, Tomas Vondra
> <tomas.vondra@2ndquadrant.com <mailto:tomas.vondra@2ndquadrant.com>> wrote:
>
>     On 04/24/2017 08:52 PM, Andres Freund wrote:
>
> ...
>
>         I've wanted that too.  It's not impossible at all.
>
>
>     Why wouldn't that be possible? We probably can't use exactly the
>     same approach as Hash, because hashjoins use custom hash table while
>     hashagg uses dynahash IIRC. But why couldn't measure the amount of
>     memory by looking at the memory context, for example?
>
>
> He said "not impossible", meaning it is possible.
>

Ah, the dreaded double negative ...


regards

-- 
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [HACKERS] to-do item for explain analyze of hash aggregates?
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] to-do item for explain analyze of hash aggregates?