Re: Uninterruptible long planning of a query with too many WHERE clauses

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Uninterruptible long planning of a query with too many WHERE clauses
Дата
Msg-id 5156.1542039670@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Uninterruptible long planning of a query with too many WHEREclauses  (Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>)
Список pgsql-hackers
Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru> writes:
> El 11/11/18 a las 07:38, Tom Lane escribió:
>> I think you have the right basic idea, but we don't have to completely
>> lobotomize the bitmap-and search logic in order to cope with this.
>> This code is only trying to figure out which paths are potentially
>> redundant, so for a path with too many quals, we can just deem it
>> not-redundant, as attached.

> Thanks for the patch, looks good to me.

Pushed, thanks for reviewing.

            regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Removal of unnecessary CommandCounterIncrement() when doing ONCOMMIT DELETE ROWS
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation