Re: explain HashAggregate to report bucket and memory stats - Mailing list pgsql-hackers

From Andres Freund
Subject Re: explain HashAggregate to report bucket and memory stats
Date
Msg-id 20200313172707.tiaf3tdsslam77ne@alap3.anarazel.de
Whole thread Raw
In response to Re: explain HashAggregate to report bucket and memory stats  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: explain HashAggregate to report bucket and memory stats  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
Hi,

On 2020-03-13 10:15:46 -0700, Jeff Davis wrote:
> Also, is there a reason you report two different memory values
> (hashtable and tuples)? I don't object, but it seems like a little too
> much detail.

Seems useful to me - the hashtable is pre-allocated based on estimates,
whereas the tuples are allocated "on demand". So seeing the difference
will allow to investigate the more crucial issue...

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: James Coleman
Date:
Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort)
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Incremental sort (was: PoC: Partial sort)