Re: Query never completes with an OR condition - Mailing list pgsql-general

From Stephen Frost
Subject Re: Query never completes with an OR condition
Date
Msg-id 20181203181549.GL3415@tamriel.snowman.net
Whole thread Raw
In response to Re: Query never completes with an OR condition  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-general
Greetings,

* Andrew Gierth (andrew@tao11.riddles.org.uk) wrote:
> >>>>> "Kenneth" == Kenneth Marshall <ktm@rice.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

Attachment

pgsql-general by date:

Previous
From: C GG
Date:
Subject: DROP CASCADE transitive dependencies
Next
From: Tom Lane
Date:
Subject: Re: DROP CASCADE transitive dependencies