Re: POC: GROUP BY optimization - Mailing list pgsql-hackers

From Dmitry Dolgov
Subject Re: POC: GROUP BY optimization
Date
Msg-id 20201026085721.g6h5xljxvodnmk34@localhost
Whole thread Raw
In response to Re: POC: GROUP BY optimization  (Pavel Borisov <pashkin.elfe@gmail.com>)
Responses Re: POC: GROUP BY optimization
List pgsql-hackers
> On Mon, Oct 26, 2020 at 12:44:58PM +0400, Pavel Borisov wrote:
> >
> >
> > I wonder if anyone has plans to try again with this optimization in v14
> > cycle? The patches no longer apply thanks to the incremental sort patch,
> > but I suppose fixing that should not be extremely hard.
> >
> > I found this feature interesting and I'd like to join.
> PFA the updated version of the patch made fully compatible with changes in
> v13 and I suppose it is ready to be reviewed for v14.
>
> Main things changed:
> 1. Patch is made compatible with new lists representation ( 1cff1b95ab6d )
> 2. Patch is made compatible with the incremental sort ( d2d8a229bc58 and
> ba3e76cc571e )
> 3. Tests are changed to represent changes in keys numbering and
> naming convention in the plan ( 55a1954da16 and 6ef77cf46e8 )
>
> As always your ideas are very much welcome!

Hi,

Thanks for your interest! FYI there is a new thread about this topic [1]
with the next version of the patch and more commentaries (I've created
it for visibility purposes, but probably it also created some confusion,
sorry for that).

[1]: https://www.postgresql.org/message-id/flat/CA%2Bq6zcW_4o2NC0zutLkOJPsFt80megSpX_dVRo6GK9PC-Jx_Ag%40mail.gmail.com



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: default result formats setting
Next
From: Heikki Linnakangas
Date:
Subject: Re: select_common_typmod