Re: Group by reordering optimization

2020-09-16 Thread Dmitry Dolgov
> On Tue, Sep 01, 2020 at 11:08:54PM +0200, Tomas Vondra wrote: > On Tue, Sep 01, 2020 at 01:15:31PM +0200, Dmitry Dolgov wrote: > > Hi, > > > > Better late than never, to follow up on the original thread [1] I would > > like to > > continue the discussion with the another version of the patch fo

Re: Group by reordering optimization

2020-09-02 Thread Tomas Vondra
On Tue, Sep 01, 2020 at 03:09:14PM -0700, Peter Geoghegan wrote: On Tue, Sep 1, 2020 at 2:09 PM Tomas Vondra wrote: >* Instead of changing the order directly, now patch creates another patch with > modifier order of clauses. It does so for the normal sort as well as for > incremental sort. Th

Re: Group by reordering optimization

2020-09-01 Thread Peter Geoghegan
On Tue, Sep 1, 2020 at 2:09 PM Tomas Vondra wrote: > >* Instead of changing the order directly, now patch creates another patch > >with > > modifier order of clauses. It does so for the normal sort as well as for > > incremental sort. The whole thing is done in two steps: first it finds a > >

Re: Group by reordering optimization

2020-09-01 Thread Tomas Vondra
On Tue, Sep 01, 2020 at 01:15:31PM +0200, Dmitry Dolgov wrote: Hi, Better late than never, to follow up on the original thread [1] I would like to continue the discussion with the another version of the patch for group by reordering optimization. To remind, it's about reordering of group by clau