Removing Inner Joins

From: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Removing Inner Joins
Date: 2013-07-09 06:20:27
Message-ID: CAOeZVif9+2DwemkkAdcua1mftxSoeEtDBbUJE_DXjVJoqy=T_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2013-07-09 06:31:15 Re: Removing Inner Joins
Previous Message Hitoshi Harada 2013-07-09 06:00:16 Re: [PATCH] Add transforms feature