"Lampa" <lampacz@gmail.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
