Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: More thoughts on sorting
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: PFC <lists(at)peufeu(dot)com>
- Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: More thoughts on sorting
- Date: Fri, 31 Jul 2009 09:51:57 -0400
- Message-id: <18412.1249048317@sss.pgh.pa.us> <text/plain>
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. regards, tom lane
- References:
- More thoughts on sorting
- From: PFC
- More thoughts on sorting
- Prev by Date: Re: SE-PostgreSQL Specifications
- Next by Date: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
- Previous by thread: More thoughts on sorting
- Next by thread: Occasional failures on buildfarm member eukaryote
- Indexes: