Re: Create Index Performance Issue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rudolf van der Leeden <vanderleeden(at)logicunited(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Create Index Performance Issue
Date: 2008-06-04 14:45:35
Message-ID: 24530.1212590735@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Rudolf van der Leeden <vanderleeden(at)logicunited(dot)com> writes:
> [ different times to build a varchar index on allegedly identical
> installations ]

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.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jonah H. Harris 2008-06-04 16:01:32 Re: Postgres security issue - protecting datafiles
Previous Message Tom Lane 2008-06-04 14:28:29 Re: unrecognized configuration parameter "synchronize_seqscans"