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

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Greg Stark <stark(at)mit(dot)edu>, 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-20 13:30:53
Message-ID: f4e9a809-9404-0706-efd9-f4d1f212fee7@iki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 20/11/2020 08:31, Michael Paquier wrote:
> On Thu, Nov 19, 2020 at 08:47:51AM +0200, Heikki Linnakangas wrote:
>> Yeah, I believe it's always been like that. Yeah, arguably it should be
>> backpatched. I felt conservative and didn't backpatch, but feel free to do
>> it if you think it should be.
>
> +1 for a backpatch. The difference in runtime for EXPLAIN in this case
> is quite something.

That's two votes for backpatching. Ok, I'll go do it.

- Heikki

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2020-11-20 13:31:20 Re: parsing pg_ident.conf
Previous Message Peter Eisentraut 2020-11-20 13:14:44 Re: Improve handling of parameter differences in physical replication