Optimizer Path Candidates difference in 9.1.3 and 9.2 beta1

Поиск
Список
Период
Сортировка
От Qi Huang
Тема Optimizer Path Candidates difference in 9.1.3 and 9.2 beta1
Дата
Msg-id BAY159-W3281E933B360B8221D8279A3E70@phx.gbl
обсуждение исходный текст
Ответы Re: Optimizer Path Candidates difference in 9.1.3 and 9.2 beta1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi, hackers
    I modified the code in add_path() a bit so that all the query path candidates inside pathlist will not be removed and all new path will be added into the pathlist, thus all path candidates are kept in pathlist. I then tested a four-relation query. In 9.1.3, I can see thousands of candidates in the final RelOptInfo, and some of them are even busy trees. But in 9.2 beta1 which I forked from github, there are no such busy trees and only about 50 join path in total, which should match the requirement of System R algo. Is there any modification regarding the system R algo in the new release? And something wrong in algo in 9.1.3?
    Thanks
   

Best Regards
Huang Qi Victor
Computer Science of National University of Singapore

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Posix Shared Mem patch
Следующее
От: "Etsuro Fujita"
Дата:
Сообщение: Re: [PATCH] Lazy hashaggregate when no aggregation is needed