| From: | Rudolf van der Leeden <vanderleeden(at)logicunited(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Create Index Performance Issue |
| Date: | 2008-06-06 19:54:34 |
| Message-ID: | EAF046AD-08A3-4238-949C-C3447672E888@logicunited.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-06-06 21:19:40 | Re: invalid page header in block 29 of relation "pg_type" |
| Previous Message | Peter Eisentraut | 2008-06-06 13:04:25 | Re: UUID generation functions |