Re: [PERFORM] AND OR combination: index not being used

2005-05-12 Thread David Teran 
On 12.05.2005, at 16:15, Tom Lane wrote:
David Teran <[EMAIL PROTECTED]> writes:
Any hint how
to force postgres to use the index even with more OR parts?
More up-to-date statistics would evidently help; the thing is 
estimating
hundreds of rows returned and actually finding none.

I always do a 'vacuum analyze' if something does not work as expected. 
But this did not help. Any other tip?

regards, David
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [PERFORM] AND OR combination: index not being used

2005-05-12 Thread Tom Lane 
David Teran <[EMAIL PROTECTED]> writes:
> Any hint how 
> to force postgres to use the index even with more OR parts?

More up-to-date statistics would evidently help; the thing is estimating
hundreds of rows returned and actually finding none.

regards, tom lane

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]