Horton

Re: don't allocate HashAgg hash tables when running explain only

Greg Stark <stark@mit.edu>

View thread View on postgr.es
From: Greg Stark <stark@mit.edu>
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Alexey Bashtanov <bashtanov@imap.cc>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2020-11-19T05:20:15Z
Lists: pgsql-hackers 
On Wed, 18 Nov 2020 at 05:40, Heikki Linnakangas <hlinnaka@iki.fi> wrote:
>
> On 13/11/2020 18:10, Alexey Bashtanov wrote:
>> > I would appreciate if someone could have a look at the patch attached,
> > which makes executor skip initializing hash tables when doing explain only.
>
> Makes sense. Committed, thanks for the patch!


Egads. That seems like a backpatchable bug fix to me. Have we been
doing this all along?!

-- 
greg

Commits

  1. Skip allocating hash table in EXPLAIN-only mode.