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
pgpSc4MeqUFZ4.pgp
Description: PGP signature
