From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200501040016.j040GdK04731@candle.pha.pa.us>
Subject: Re: Doc patch needed: encodings?
In-Reply-To: <200501040112.31525.peter_e@gmx.net>
To: Peter Eisentraut <peter_e@gmx.net>
Date: Mon, 3 Jan 2005 19:16:39 -0500 (EST)
Cc: Tom Lane <tgl@sss.pgh.pa.us>, josh@agliodbs.com,
	PostgreSQL Docs <pgsql-docs@postgresql.org>
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > I have applied the following patch to mention non-C locales affect
> > LIKE.
> 
> I don't think it's accurate to say that there is a performance impact.  
> The only impact is that you need to create a different kind of index.

Well, there is a performance impact to using the locale functions, and
you can't use ordinary indexes for LIKE, just special ones.  Is there
better text I should use?

I used "performance impact" in the reference text to suggest there is an
issue and they might want to read the locale section.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073