On Wed, Jun 19, 2024 at 6:02 PM Pavel Borisov wrote:
> On Wed, 19 Jun 2024 at 05:27, Alexander Korotkov wrote:
>>
>> On Tue, Jun 18, 2024 at 4:14 PM Pavel Borisov wrote:
>> >> Controls if the query planner will produce a plan which will provide
>> >> GROUP BY keys presorted in the order of keys
Hi, Alexander!
On Wed, 19 Jun 2024 at 05:27, Alexander Korotkov
wrote:
> On Tue, Jun 18, 2024 at 4:14 PM Pavel Borisov
> wrote:
> >> Controls if the query planner will produce a plan which will provide
> GROUP BY keys presorted in the order of keys of a child
> node of the plan, such as an inde
On Tue, Jun 18, 2024 at 4:14 PM Pavel Borisov wrote:
>> Controls if the query planner will produce a plan which will provide
>> GROUP BY keys presorted in the order of keys of a child
>> node of the plan, such as an index scan. When disabled, the query planner
>> will produce a plan with GROUP
>
> Controls if the query planner will produce a plan which will provide
> GROUP BY keys presorted in the order of keys of a child
> node of the plan, such as an index scan. When disabled, the query planner
> will produce a plan with GROUP BY keys only reordered to
> match
> the ORDER BY clause, if
Hi, Alexander!
On Tue, 18 Jun 2024 at 16:13, Alexander Korotkov
wrote:
> On Tue, Jun 18, 2024 at 9:14 AM Andrei Lepikhov wrote:
> > On 6/18/24 09:32, Bruce Momjian wrote:
> > > This commit added enable_group_by_reordering:
> > >
> > > commit 0452b461bc4
> > > Author: Alexander Korot
On Tue, Jun 18, 2024 at 9:14 AM Andrei Lepikhov wrote:
> On 6/18/24 09:32, Bruce Momjian wrote:
> > This commit added enable_group_by_reordering:
> >
> > commit 0452b461bc4
> > Author: Alexander Korotkov
> > Date: Sun Jan 21 22:21:36 2024 +0200
> > It mentions it was added as
On 6/18/24 09:32, Bruce Momjian wrote:
This commit added enable_group_by_reordering:
commit 0452b461bc4
Author: Alexander Korotkov
Date: Sun Jan 21 22:21:36 2024 +0200
It mentions it was added as a GUC to postgresql.conf, but I see no SGML
docs for this new GUC value.
This commit added enable_group_by_reordering:
commit 0452b461bc4
Author: Alexander Korotkov
Date: Sun Jan 21 22:21:36 2024 +0200
Explore alternative orderings of group-by pathkeys during
optimization.
When evaluating a query wit
