Re: Removing Inner Joins - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: Removing Inner Joins
Date
Msg-id CAFjFpRcZw0=oDhcrCNNWZUwKY=DajLVL0VhgC4oB-isXK6-NBA@mail.gmail.com
Whole thread Raw
In response to Re: Removing Inner Joins  (Atri Sharma <atri.jiit@gmail.com>)
Responses Re: Removing Inner Joins
List pgsql-hackers
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.


On Tue, Jul 9, 2013 at 12:21 PM, Atri Sharma <atri.jiit@gmail.com> wrote:
My main point here is researching how difficult it is to add
functionality in the planner to allow it to to detect and make
decisions on foreign keys present in the outer relation.

I think that if this is added, rest of the work would be much easier.
I amy be completely wrong,though.

Thoughts/Comments?

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



--
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Postgres Database Company

pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: pgbench patches
Next
From: Amit Kapila
Date:
Subject: Re: Performance Improvement by reducing WAL for Update Operation