Re: OR clause causing strange index performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Doug Y <dylists(at)ptd(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: OR clause causing strange index performance
Date: 2004-05-21 06:53:37
Message-ID: 24812.1085122417@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Doug Y <dylists(at)ptd(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Charlie Clark 2004-05-21 07:28:34 Problem with JOINS
Previous Message Manuel Sugawara 2004-05-20 21:43:38 Re: Simple view confuses PostgreSQL query planning