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

From Dmitry Dolgov
Subject Re: POC: GROUP BY optimization
Date
Msg-id 20201026104040.6bigvej6f55vjvgp@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 01:28:59PM +0400, Pavel Borisov wrote:
> > 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).
> >
> > Thanks!
>
> I made a very quick look at your updates and noticed that it is intended to
> be simple and some parts of the code are removed as they have little test
> coverage. I'd propose vice versa to increase test coverage to enjoy more
> precise cost calculation and probably partial grouping.
>
> Or maybe it's worth to benchmark both patches and then re-decide what we
> want more to have a more complicated or a simpler version.
>
> Good to know that this feature is not stuck anymore and we have more than
> one proposal.
> Thanks!

Just to clarify, the patch that I've posted in another thread mentioned
above is not an alternative proposal, but a development of the same
patch I had posted in this thread. As mentioned in [1], reduce of
functionality is an attempt to reduce the scope, and as soon as the base
functionality looks good enough it will be returned back.

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



pgsql-hackers by date:

Previous
From: Pavel Borisov
Date:
Subject: Re: POC: GROUP BY optimization
Next
From: Muhammad Usama
Date:
Subject: Re: pgbench - add pseudo-random permutation function