Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
Дата
Msg-id CAFj8pRCRooD2--9T2uQ8+A9X1v-ToM0VBkJmWoNuR8e4R9dgiQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause  ("Sven R. Kunze" <srkunze@mail.de>)
Список pgsql-performance
Дерево обсуждения


2016-09-29 20:49 GMT+02:00 Sven R. Kunze <srkunze@mail.de>:
On 29.09.2016 20:12, Pavel Stehule wrote:
In ideal world then plan should be independent on used form. The most difficult is safe estimation of OR predicates. With correct estimation the transformation to UNION form should not be necessary I am think.

 Ah, okay. That's interesting.

So how can I help here?

try to write a patch :) or better, help with enhancing PostgreSQL's estimation model. Tomas Vondra is working 2 years on multicolumn statistics. He needs help with review.

Regards

Pavel

Regards,
Sven



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

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

Предыдущее
От: "Sven R. Kunze"
Дата:
Сообщение: Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause