Postgres Pro
Downloads
Home   >   mailing lists

Re: don't allocate HashAgg hash tables when running explain only - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: don't allocate HashAgg hash tables when running explain only
Date
Msg-id 20201120063122.GE8506@paquier.xyz
Whole thread Raw
In response to Re: don't allocate HashAgg hash tables when running explain only  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: don't allocate HashAgg hash tables when running explain only  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Use macros for calculating LWLock offset
Next
From: Fujii Masao
Date:
Subject: Re: bad logging around broken restore_command