Horton

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

Heikki Linnakangas <hlinnaka@iki.fi>

View thread View on postgr.es
From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Michael Paquier <michael@paquier.xyz>
Cc: Greg Stark <stark@mit.edu>, Alexey Bashtanov <bashtanov@imap.cc>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2020-11-20T13:30:53Z
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

Commits

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