Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

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

From Andrey Lepikhov
Subject Re: Removing unneeded self joins
Date
Msg-id 05469e80-454b-41d7-d04f-421f42bbd4a9@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 5/7/2023 21:28, Andrey Lepikhov wrote:
> Hi,
> 
> During the significant code revision in v.41 I lost some replacement 
> operations. Here is the fix and extra tests to check this in the future.
> Also, Tom added the JoinDomain structure five months ago, and I added 
> code to replace relids for that place too.
> One more thing, I found out that we didn't replace SJs, defined by 
> baserestrictinfos if no one self-join clause have existed for the join. 
> Now, it is fixed, and the test has been added.
> To understand changes readily, see the delta file in the attachment.
Here is new patch in attachment. Rebased on current master and some 
minor gaffes are fixed.

-- 
regards,
Andrey Lepikhov
Postgres Professional

Attachment

pgsql-hackers by date:

Previous
From: Suraj Kharage
Date:
Subject: Server crash on RHEL 9/s390x platform against PG16
Next
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: [PoC] pg_upgrade: allow to upgrade publisher node