From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rudolf van der Leeden <vanderleeden@logicunited.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Create Index Performance Issue
Date: Wed, 04 Jun 2008 10:45:35 -0400
Message-ID: <24530.1212590735@sss.pgh.pa.us> (raw)
In-Reply-To: <7EB14E30-23D1-49FF-AB57-E53A8CD3AE72@logicunited.com>
References: <7EB14E30-23D1-49FF-AB57-E53A8CD3AE72@logicunited.com>
Rudolf van der Leeden <vanderleeden@logicunited.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, vanderleeden@logicunited.com
Subject: Re: Create Index Performance Issue
In-Reply-To: <24530.1212590735@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox