Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group