Re: BUG #4341: planner doesn't using index for = operation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Lampa" <lampacz(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4341: planner doesn't using index for = operation
Date: 2008-08-06 15:20:49
Message-ID: 14352.1218036049@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Lampa" <lampacz(at)gmail(dot)com> writes:
> With varchar_pattern_ops planner is not using index(first explain) but when
> use LIKE index is used.
> I must create another index without varchar_pattern_ops flag to get equal
> speed results.

Yup, this is expected behavior because '=' is not part of the
varchar_pattern_ops operator class.

(Things will be better in 8.4, but it's not possible to fix it in
existing release branches.)

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Blanco, Jose 2008-08-06 18:44:14 Oder by not working
Previous Message Pavel Stehule 2008-08-06 15:06:36 Re: BUG #4342: upper, lower, initcap do not work with umlaute?