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
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 |