Postgres Pro
Downloads
Home   >   mailing lists

Re: OR clause causing strange index performance - Mailing list pgsql-sql

From Tom Lane
Subject Re: OR clause causing strange index performance
Date
Msg-id 24812.1085122417@sss.pgh.pa.us
Whole thread Raw
In response to OR clause causing strange index performance  (Doug Y <dylists@ptd.net>)
List pgsql-sql
Tree view 
Doug Y <dylists@ptd.net> writes:
> Is there any way to get this query to use the correct index condition so 
> that it runs in a reasonable amount of time?

I think CVS tip (7.5-to-be) would handle this better, but it's hard to
be sure since you didn't provide a self-contained test case.
        regards, tom lane

pgsql-sql by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: Simple view confuses PostgreSQL query planning
Next
From: Richard Huxton
Date:
Subject: Re: v7.2 triggers and foreign keys