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

2008-08-06 Thread Tom Lane
"Lampa" <[EMAIL PROTECTED]> 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 va

[BUGS] BUG #4341: planner doesn't using index for = operation

2008-08-06 Thread Lampa
The following bug has been logged online: Bug reference: 4341 Logged by: Lampa Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Debian 2.6.18-6-amd64 #1 SMP Sun Feb 10 17:50:19 UTC 2008 x86_64 GNU/Linux Description:planner doesn't using ind