Re: intercepting where clause on a view or other performance tweak - Mailing list pgsql-performance

From Tom Lane
Subject Re: intercepting where clause on a view or other performance tweak
Date
Msg-id 15097.1353080505@sss.pgh.pa.us
Whole thread Raw
In response to Re: intercepting where clause on a view or other performance tweak  (Russell Keane <Russell.Keane@inps.co.uk>)
List pgsql-performance
Russell Keane <Russell.Keane@inps.co.uk> writes:
> Sorry, I should've added that in the original description.
> I have an index on search_key and it's never used.

Did you pay attention to the point about the nondefault operator class?
If the LIKE pattern is left-anchored and as selective as your example
implies, the planner certainly ought to try to use a compatible index.

            regards, tom lane


pgsql-performance by date:

Previous
From: Russell Keane
Date:
Subject: Re: intercepting where clause on a view or other performance tweak
Next
From: Craig James
Date:
Subject: Re: PostgreSQL strange query plan for my query