Re: Optimizer differences between 7.2 and 7.3

От: SZUCS Gábor
Тема: Re: Optimizer differences between 7.2 and 7.3
Дата: ,
Msg-id: 012201c34f61$b20993e0$0403a8c0@fejleszt4
(см: обсуждение, исходный текст)
Ответ на: Optimizer differences between 7.2 and 7.3  (Jeff Boes)
Ответы: Re: Optimizer differences between 7.2 and 7.3  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

Optimizer differences between 7.2 and 7.3  (Jeff Boes, )
 Re: Optimizer differences between 7.2 and 7.3  (Richard Huxton, )
 Re: Optimizer differences between 7.2 and 7.3  (SZUCS Gábor, )
  Re: Optimizer differences between 7.2 and 7.3  (Tom Lane, )

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" <>
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 по дате сообщения:

От: "Alexander Priem"
Дата:
Сообщение: Re: Tuning PostgreSQL
От: Josh Berkus
Дата:
Сообщение: Re: Tuning PostgreSQL