Re: Query never completes with an OR condition

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Kenneth Marshall <ktm(at)rice(dot)edu>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Query never completes with an OR condition
Date: 2018-12-03 18:09:14
Message-ID: 87y39632td.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "Kenneth" == Kenneth Marshall <ktm(at)rice(dot)edu> 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)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message C GG 2018-12-03 18:13:00 DROP CASCADE transitive dependencies
Previous Message David G. Johnston 2018-12-03 18:06:11 Re: How to watch for schema changes