Re: Index not used with or condition - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Index not used with or condition
Date
Msg-id 20050207114605.GB27546@uio.no
Whole thread Raw
In response to Re: Index not used with or condition  (Antony Paul <antonypaul24@gmail.com>)
Responses Re: Index not used with or condition  (Antony Paul <antonypaul24@gmail.com>)
List pgsql-performance
On Mon, Feb 07, 2005 at 04:44:07PM +0530, Antony Paul wrote:
> On more investigation I found that index scan is not used if the query
> have a function in it like lower() and an index exist for lower()
> column.

What version are you using? 8.0 had fixes for this situation.

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: "Joost Kraaijeveld"
Date:
Subject: Is this possible / slow performance?
Next
From: Jan Poslusny
Date:
Subject: Re: Index not used with or condition