Removing Inner Joins - Mailing list pgsql-hackers

From Atri Sharma
Subject Removing Inner Joins
Date
Msg-id CAOeZVif9+2DwemkkAdcua1mftxSoeEtDBbUJE_DXjVJoqy=T_g@mail.gmail.com
Whole thread Raw
Responses Re: Removing Inner Joins
List pgsql-hackers
Hi all,

I was reading about the plans to add functionality to the planner to
remove redundant inner joins where there is no member of the inner
relation present in the target list and the inner relation is only
used for the join clause. Also, we have a foreign key in the outer
relation to the inner relation.

Where are we with that functionality atm? Do we have plans to move forward?

Also, how difficult is it to go ahead with it?

Regards,

Atri


--
Regards,

Atri
l'apprenant



pgsql-hackers by date:

Previous
From: Hitoshi Harada
Date:
Subject: Re: [PATCH] Add transforms feature
Next
From: Peter Geoghegan
Date:
Subject: Re: Removing Inner Joins