Re: Consider the number of columns in the sort cost model - Mailing list pgsql-hackers

From Andrei Lepikhov
Subject Re: Consider the number of columns in the sort cost model
Date
Msg-id 86bd6d3c-c541-4047-924a-c883443c3d3f@gmail.com
Whole thread Raw
In response to Re: Consider the number of columns in the sort cost model  (Alena Rybakina <a.rybakina@postgrespro.ru>)
List pgsql-hackers
On 10/31/24 21:00, Alena Rybakina wrote:
> On 29.10.2024 05:47, Andrei Lepikhov wrote:
> I played around with the examples a bit and couldn't figure out 
> something. When I added the same values ​​to different columns - firstly 
> in a, later in b, the order of the columns for sort operation doesn't 
> change. Isn't this a mistake?
This feature implements a cost-based approach to choosing the grouping 
clauses' order. What kind of 'mistake' do you see here? Is there 
something wrong with the costs, or do you see a bug in the cost 
calculation code? Please specify your request.

-- 
regards, Andrei Lepikhov




pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Remove useless casts to (void *)
Next
From: Richard Guo
Date:
Subject: Re: Eager aggregation, take 3