Re: More thoughts on sorting

On Sat, Aug 01, 2009 at 09:37:11AM +0200, PFC wrote:
>> PFC <lists(at)peufeu(dot)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.
>>
> Actually, I think (see the bottom of my last email) that this would be a
> good argument for the per-column COLLATE patch...

Standard SQL COLLATE support is per column anyway, so just implementing
that will solve all the problems anyway.

Have a nice day,

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.