Re: Removing Inner Joins

Поиск
Список
Период
Сортировка
От Ashutosh Bapat
Тема Re: Removing Inner Joins
Дата
Msg-id CAFjFpRcZw0=oDhcrCNNWZUwKY=DajLVL0VhgC4oB-isXK6-NBA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Removing Inner Joins  (Atri Sharma <atri.jiit@gmail.com>)
Ответы Re: Removing Inner Joins  (Atri Sharma <atri.jiit@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: pgbench patches
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Performance Improvement by reducing WAL for Update Operation