Retrieving all possible join trees from PLANNER..

Поиск
Список
Период
Сортировка
От Gayathri TK
Тема Retrieving all possible join trees from PLANNER..
Дата
Msg-id 4368DBD9.1020606@ncsu.edu
обсуждение исходный текст
Ответы Re: Retrieving all possible join trees from PLANNER..  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hello all,

I am using Postgres to do my Masters' thesis work. Given a query, i want 
to know all possible join plan trees for that query.

This information can be got from 
src/backend/optimizer/path/allpaths.c/make_one_rel_by_joins() method.
[ie] more specifically, I need joinitems[levels_needed]

The information i need is a temporary result generated by planner and is 
not passed on to later stages. Hence If i add a command, i wont have 
this infomation by the time ProcessUtility() method is called.

How do i efficiently retrieve this information?

The input to my method is a file containing queries, and output should 
be all possible join plan trees for each query in the file...

Thanks in advance,
Gayathri TK


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 8.1RC1 fails to build on OS X (10.4)
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: pg_restore [archiver] file offset in dump file