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

From Andrey Lepikhov
Subject Re: Removing unneeded self joins
Date
Msg-id c0f41cba-659d-c6e1-7fb4-85e703dc2395@postgrespro.ru
Whole thread Raw
In response to Re: Removing unneeded self joins  (Greg Stark <stark@mit.edu>)
Responses Re: Removing unneeded self joins  (Ronan Dunklau <ronan.dunklau@aiven.io>)
List pgsql-hackers
New version of the feature.
Here a minor bug with RowMarks is fixed. A degenerated case is fixed, 
when uniqueness of an inner deduced not from join quals, but from a 
baserestrictinfo clauses 'x=const', where x - unique field.
Code, dedicated to solve second issue is controversial, so i attached 
delta.txt for quick observation.
Maybe we should return to previous version of code, when we didn't split 
restriction list into join quals and base quals?

-- 
Regards
Andrey Lepikhov
Postgres Professional
Attachment

pgsql-hackers by date:

Previous
From: Amul Sul
Date:
Subject: Re: Correct comment in ProcedureCreate() for pgstat_create_function() call.
Next
From: Amit Kapila
Date:
Subject: Re: Data is copied twice when specifying both child and parent table in publication