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

From: Greg Stark <stark(at)mit(dot)edu>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Alexey Bashtanov <bashtanov(at)imap(dot)cc>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: don't allocate HashAgg hash tables when running explain only
Date: 2020-11-19 05:20:15
Message-ID: CAM-w4HO=+z2sFcDVdkBD_0xZO676A=8D2NJjVAr23RLs5DaCfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 18 Nov 2020 at 05:40, Heikki Linnakangas <hlinnaka(at)iki(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro Horiguchi 2020-11-19 05:23:33 Re: Protect syscache from bloating with negative cache entries
Previous Message Thomas Munro 2020-11-19 05:01:14 Re: Cache relation sizes?