Re: [HACKERS] How does postgres store the join predicate for a relation in a given query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] How does postgres store the join predicate for a relation in a given query
Дата
Msg-id 2239.1507830265@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] How does postgres store the join predicate for arelation in a given query  (Gourav Kumar <gourav1905@gmail.com>)
Ответы Re: [HACKERS] How does postgres store the join predicate for arelation in a given query  (Gourav Kumar <gourav1905@gmail.com>)
Список pgsql-hackers
Gourav Kumar <gourav1905@gmail.com> writes:
> My objective is to construct join graph from a given query.
> A join graph, has a node for each relation involved in a join, and an edge
> between two relations if they share a join predicate among them.

Hm, well, you could adapt the logic in have_relevant_joinclause() and
have_relevant_eclass_joinclause().  Or maybe you could just use them
as-is ... depends on what you have in mind to do with join clauses
that mention 3 or more relations.
        regards, tom lane


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] On markers of changed data
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] Parallel Append implementation