This locale setting will prevent use of index optimization for LIKE and regexp searches. (sl_SI.ISO_8859-2)

From: Tomaz Borstnar <tomaz(dot)borstnar(at)over(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: This locale setting will prevent use of index optimization for LIKE and regexp searches. (sl_SI.ISO_8859-2)
Date: 2000-12-27 14:41:20
Message-ID: 5.0.2.1.0.20001227112041.02f867e0@193.189.189.100
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

Installed 7.1beta1, set LC_ALL to sl_SI.ISO_8859-2 and initialized the
database with initdb and got this:

NOTICE: Initializing database with sl_SI.ISO_8859-2 collation order.
This locale setting will prevent use of index optimization for
LIKE and regexp searches. If you are concerned about speed of
such queries, you may wish to set LC_COLLATE to "C" and
re-initdb. For more information see the Administrator's Guide.

How much can this affect and if there is any way to make this as fast as
possible?

Tomaz

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2000-12-27 15:09:32 SSL
Previous Message Peter Eisentraut 2000-12-27 11:16:26 List metadata tags (was Re: Auto Increment)