Re: Uninterruptible long planning of a query with too many WHERE clauses - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Uninterruptible long planning of a query with too many WHERE clauses
Date
Msg-id 5156.1542039670@sss.pgh.pa.us
Whole thread Raw
In response to Re: Uninterruptible long planning of a query with too many WHEREclauses  (Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Removal of unnecessary CommandCounterIncrement() when doing ONCOMMIT DELETE ROWS
Next
From: Tom Lane
Date:
Subject: Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation