Re: Query never completes with an OR condition

2018-12-03 Thread Stephen Frost
Greetings, * Andrew Gierth (and...@tao11.riddles.org.uk) wrote: > > "Kenneth" == Kenneth Marshall writes: > > Kenneth> The individual queries run as expected, but when the OR > Kenneth> condition is added, it never finishes. > > http://blog.rhodiumtoad.org.uk/2017/01/22/performance-issues

Re: Query never completes with an OR condition

2018-12-03 Thread Andrew Gierth
> "Kenneth" == Kenneth Marshall writes: Kenneth> The individual queries run as expected, but when the OR Kenneth> condition is added, it never finishes. http://blog.rhodiumtoad.org.uk/2017/01/22/performance-issues-with-ored-conditions/ -- Andrew (irc:RhodiumToad)

Query never completes with an OR condition

2018-12-03 Thread Kenneth Marshall
Hi, I was investigating a performance problem and found a query that never completes in a reasonable amount of time even though my expectation is that it should. I am running version 9.6.6. I do not see anything in the 9.6.* release notes that mention this problem. The individual queries run as ex