Tom Lane wrote:
>"Joshua D. Drake" <jd@commandprompt.com> writes:
>
>
>>If you look at the second line in each explain it is the sort that is
>>causing the grief.
>>
>>
>
>The aggregation is a great deal worse as well. I suspect that for some
>reason the comparison operations involved in the sorting and grouping
>are much slower on the FC3 machine. What are the data types of the
>leading sort keys ... and are you *certain* the FC3 database has
>LC_COLLATE and LC_CTYPE set to C?
>
>
Well I definately did a initdb --no-locale
34 bin/initdb -D cdata --no-locale
But I didn't specify LC_COLLATE or LC_CTYPE explicitly.
I did set LANG="C" in /etc/sysconfig/i18n however.
Sincerely,
Joshua D. Drake
> regards, tom lane
>
>
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL