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

Поиск
Список
Период
Сортировка
От Gourav Kumar
Тема [HACKERS] How does postgres store the join predicate for a relation in a given query
Дата
Msg-id CAPzqDmhQN3cOZns1foyaQaKap3Xt4RoSXr+8CS--u5o1M43Yxw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] How does postgres store the join predicate for arelation in a given query  (Nico Williams <nico@cryptonector.com>)
Re: [HACKERS] How does postgres store the join predicate for arelation in a given query  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers

Hi all,

When you fire a query in postgresql, it will first parse the query and create the data structures for storing various aspects of the query and executing the query. (Like RangeTblEntry, PlannerInfo, RangeOptInfo etc.).

I want to know how does postgresql stores the join predicates of a query. Like which data structure is used to store the join predicates.

How can we find the join predicates applied on a relation from relid, Oid or RangeTblEntry ?

I want to construct a join graph for a given query, for which I need the join predicates between two relations.


--
Thanks,
Gourav Kumar

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

Предыдущее
От: Petr Jelinek
Дата:
Сообщение: [HACKERS] Re: [BUGS] 10.0: Logical replication doesn't execute BEFORE UPDATE OF trigger
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] [COMMITTERS] pgsql: Fix freezing of a dead HOT-updatedtuple