Re: Problems with index-scan on regexp in 8.1 - Mailing list pgsql-hackers

From Lars Kanis
Subject Re: Problems with index-scan on regexp in 8.1
Date
Msg-id 200511080923.42109.kanis@comcard.de
Whole thread Raw
In response to Re: Problems with index-scan on regexp in 8.1  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
Am Montag, 7. November 2005 14:13 schrieb Martijn van Oosterhout:
> On Mon, Nov 07, 2005 at 07:50:20AM +0100, Lars Kanis wrote:
> > We're using Postgres 8.0.2 on SuSE10.0 (64-Bit). Tests on 8.1 beta 4 have
> > shown no problems but this one:
> >
> >   SELECT * FROM mitglieder WHERE lower(vorname::text)='lars'
> >
> > does a bitmap-index-scan like this:
>
> Check your locales. For non-ASCII locales the normal shortcuts for
> regex optimisation can't apply. Evidently your old installation uses a
> different locale from your new one.
>
> You should be able to make this work by declaring your index with
> "text_pattern_ops", like so:
>
> CREATE INDEX myindex ON mytable(mycolumn text_pattern_ops);
>
> Hope this helps,

Thank you much, it helps.
The initdb-locales were different. pattern_ops work quite fine with the
regexps.

So I don't have any complaints to 8.1.

kind regards
Lars Kanis

pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Enums again
Next
From: "Pavel Stehule"
Date:
Subject: Re: Supporting NULL elements in arrays