X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 0455147580B
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2003 10:06:09 -0500 (EST)
Received: from innoviatech.com (mailgate.innoviatech.com [193.195.86.89])
	by postgresql.org (Postfix) with ESMTP id D6EEF474E44
	for <pgsql-sql@postgresql.org>; Thu, 27 Mar 2003 10:06:07 -0500 (EST)
Received: from [10.0.0.18] ([10.0.0.18] verified)
	by innoviatech.com (CommuniGate Pro SMTP 4.0.1)
	with ESMTP id 358102; Thu, 27 Mar 2003 15:06:04 +0000
User-Agent: Microsoft-Entourage/10.1.1.2418
Date: Thu, 27 Mar 2003 15:06:01 +0000
Subject: Re: order by 
From: Julian Scarfe <julian.scarfe@ntlworld.com>
To: Jodi Kanter <jkanter@virginia.edu>
Cc: Postgres SQL List <pgsql-sql@postgresql.org>
Message-ID: <BAA8C3D9.25F98%julian.scarfe@ntlworld.com>
In-Reply-To: <007001c2f470$f4a936c0$de138f80@virginia.edu>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
X-Spam-Status: No, hits=-21.2 required=5.0
	tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,USER_AGENT_ENTOURAGE
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200303/619
X-Sequence-Number: 12657

On 27/3/03 14:55, "Jodi Kanter" <jkanter@virginia.edu> wrote:

> Other than the sort ordering are there any other problems with NOT having
> the environment set to "C?"

Pattern matching e.g. "where foo ~~ 'bar%'" doesn't use an index on foo
unless the locale is C.  This can cause a significant performance hit.  For
examples as above you can workaround by defining a substring function for a
functional index, but it's a bit clumsy.

Must get round to doing a fresh initdb one of these days... ;-)

Julian Scarfe