Re: Create Index Performance Issue - Mailing list pgsql-admin

From Rudolf van der Leeden
Subject Re: Create Index Performance Issue
Date
Msg-id EAF046AD-08A3-4238-949C-C3447672E888@logicunited.com
Whole thread Raw
In response to Re: Create Index Performance Issue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom,
your hint was 100% correct.  BINGO!
The setting of  lc_locale and lc_ctype was 'en_us' instead of 'C' as
on the other machine.
Now it works perfectly OK and with identical execution times on both
machines.
Thanks for your help and best regards,
Rudolf VanderLeeden

Am 04.06.2008 um 16:45 schrieb Tom Lane:

> Perhaps one is using C locale and the other is not?  strcmp() vs
> strcoll() is a pretty big hit.  In general it'd be worth dumping
> out the whole contents of pg_settings and diffing those two files
> to see if you missed any configuration differences.

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: UUID generation functions
Next
From: Alvaro Herrera
Date:
Subject: Re: invalid page header in block 29 of relation "pg_type"