Re: Group by reordering optimization

2020-09-16 Thread Dmitry Dolgov
ith the another version of the patch for group by > > reordering optimization. To remind, it's about reordering of group by > > clauses > > to do sorting more efficiently. The patch is rebased and modified to address > > (at least partially) the suggestions about making

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 gro

Group by reordering optimization

2020-09-01 Thread Dmitry Dolgov
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 clauses to do sorting more efficiently. The patch is rebase