Re: More thoughts on sorting - Mailing list pgsql-hackers

From PFC
Subject Re: More thoughts on sorting
Date
Msg-id op.uxy3f9nncigqcu@soyouz
Whole thread Raw
In response to Re: More thoughts on sorting  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: More thoughts on sorting  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
> PFC <lists@peufeu.com> writes:
>> - for short strings (average 12 bytes), sort is CPU-bound in strcoll()
>> - for longer strings (average 120 bytes), sort is even more CPU-bound in
>> strcoll()
>
> No news there.  If you are limited by the speed of text comparisons,
> consider using C locale.
>
>             regards, tom lane
>
Actually, I think (see the bottom of my last email) that this would be a  
good argument for the per-column COLLATE patch...


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Filtering dictionaries support and unaccent dictionary
Next
From: Dimitri Fontaine
Date:
Subject: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT