On Wed, Jul 10, 2013 at 8:29 AM, Ashutosh Bapat <ashutosh.ba...@enterprisedb.com> wrote: > AFAIK, > There is code to remove the redundant relations (joins too are relations). > But I don't remember exactly where it is. Start looking at query_planner(). > The removal of relations should happen before actually planning the joins. > >
Thanks for your reply. I am not sure if the part you mentioned is inline with the case I am talking about. The specific case I mentioned does not seem to have been implemented yet, and I was researching the roadblocks to it, hence asked on the list. Thanks and Regards, Atri -- Regards, Atri l'apprenant -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers