Re: Query never completes with an OR condition

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Query never completes with an OR condition
Дата
Msg-id 20181203181549.GL3415@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: Query never completes with an OR condition  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список 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

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: C GG
Дата:
Сообщение: DROP CASCADE transitive dependencies
Следующее
От: Tom Lane
Дата:
Сообщение: Re: DROP CASCADE transitive dependencies