Re: [HACKERS] Problems with index-scan on regexp in 8.1

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::t

Re: [HACKERS] Problems with index-scan on regexp in 8.1

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.

[HACKERS] Problems with index-scan on regexp in 8.1

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: Bitmap Heap Scan on mitglieder (cost=10.68..3770.52 rows=1051 width=226) Recheck Cond