Re: Abbreviated keys for text cost model fix - Mailing list pgsql-hackers

From Jeremy Harris
Subject Re: Abbreviated keys for text cost model fix
Date
Msg-id 54F4EC7F.2040708@wizmail.org
Whole thread Raw
In response to Re: Abbreviated keys for text cost model fix  (Jeremy Harris <jgh@wizmail.org>)
Responses Re: Abbreviated keys for text cost model fix
List pgsql-hackers
On 25/02/15 00:32, Jeremy Harris wrote:
> On 23/02/15 16:40, Tomas Vondra wrote:
>> On 22.2.2015 22:30, Peter Geoghegan wrote:
>>> You should try it with the data fully sorted like this, but with one 
>>> tiny difference: The very last tuple is out of order. How does that 
>>> look?
> 
> If this case is actually important, a merge-sort can take
> significant advantage of the partial order:

Presumably it is not, as nobody commented
on the alleged 20 or 30x speedup.





pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: alter user/role CURRENT_USER
Next
From: Andrew Dunstan
Date:
Subject: Re: Why are json <=> jsonb casts marked as explicit-only?