Re: Query never completes with an OR condition

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: Kenneth Marshall <ktm(at)rice(dot)edu>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Query never completes with an OR condition
Date: 2018-12-03 18:15:49
Message-ID: 20181203181549.GL3415@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greetings,

* Andrew Gierth (andrew(at)tao11(dot)riddles(dot)org(dot)uk) wrote:
> >>>>> "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/

There's been work to improve on this and which I know that I, at least,
would love to see make it into PostgreSQL:

https://commitfest.postgresql.org/19/1001/

Would be great if someone could look at that and try to help determine
if it's possible to ensure that the results are entirely correct.

Thanks!

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-12-03 18:26:26 Re: DROP CASCADE transitive dependencies
Previous Message C GG 2018-12-03 18:13:00 DROP CASCADE transitive dependencies