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

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
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 06:31:22
Message-ID: 20201120063122.GE8506@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2020-11-20 06:45:10 Re: bad logging around broken restore_command
Previous Message Michael Paquier 2020-11-20 06:25:50 Re: Use macros for calculating LWLock offset