> Am I correct in interpreting your comments as saying you believe that
> if we could lose the OR and the strand constraint PG would probably
> use the index properly?
No, I said I thought it could do it without that ;-). But yes, you'd
have a much less fragile query if you could lose the OR condition.
Have you looked into using a UNION ALL instead of OR to merge the two
sets of results? It sounds grotty, but might be faster...
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Curt Sampson||Date: 2003-02-15 08:29:21|
|Subject: Re: [HACKERS] WAL replay logic (was Re: Mount options for|
|Previous:||From: Tom Lane||Date: 2003-02-14 23:19:17|
|Subject: Re: performace problem after VACUUM ANALYZE |