Re: Removing unneeded self joins - Mailing list pgsql-hackers

From Konstantin Knizhnik
Subject Re: Removing unneeded self joins
Date
Msg-id bfcdcf79-d726-3986-597e-bbd9b68a67cc@postgrespro.ru
Whole thread Raw
In response to Re: Removing unneeded self joins  (Andrey Lepikhov <a.lepikhov@postgrespro.ru>)
Responses Re: Removing unneeded self joins
List pgsql-hackers

On 05.08.2019 14:24, Andrey Lepikhov wrote:
>
>
> On 02/08/2019 04:54, Thomas Munro wrote:
>> On Thu, Jun 27, 2019 at 6:42 PM Andrey Lepikhov
>> <a.lepikhov@postgrespro.ru> wrote:
>>> Version v.17 of the patch that fix the bug see in attachment.
>>
>> While moving this to the September CF, I noticed that it needs to be
>> updated for the recent pg_list.h API changes.
> The patch was updated:
> 1. Changes caused by pg_list.h API changes.
> 2. Fix the problem of joint clause_relids and required_relids changes 
> [1].
> 3. Add eclass mentions of removed relation into the kept relation 
> (field eclass_indexes was introduced by commit 3373c71553).
>
> [1] 
> https://www.postgresql.org/message-id/flat/5c21029d-81a2-c999-6744-6a898fcc9a19%40postgrespro.ru
>

One more bug is fixed in this patch: OR clauses were not correctly 
updated in case of self join removal.



-- 
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


Attachment

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: is necessary to recheck cached data in fn_extra?
Next
From: Alvaro Herrera
Date:
Subject: Re: no default hash partition