Re: Optimizer differences between 7.2 and 7.3 - Mailing list pgsql-performance

From SZUCS Gábor
Subject Re: Optimizer differences between 7.2 and 7.3
Date
Msg-id 012201c34f61$b20993e0$0403a8c0@fejleszt4
Whole thread Raw
In response to Optimizer differences between 7.2 and 7.3  (Jeff Boes <jboes@nexcerpt.com>)
Responses Re: Optimizer differences between 7.2 and 7.3
List pgsql-performance
A bit OT:

do regex ops (~, ~*) use index scan in non-"C" locales? Is it worth to
convert LIKE to regex?

G.
------------------------------- cut here -------------------------------
----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
Sent: Monday, July 07, 2003 4:40 PM


Check the locale the database was initdb'd to. You'll probably find 7.2.4 is
in the "C" locale whereas 7.3.3 isn't. The "like" comparison can only use
indexes in the "C" locale. I believe you might need to initdb again to fix
this.

--
  Richard Huxton

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html


pgsql-performance by date:

Previous
From: "SZŰCS Gábor"
Date:
Subject: Re: ugly query slower in 7.3, even slower after vacuum full analyze
Next
From: "Alexander Priem"
Date:
Subject: Tuning PostgreSQL