[HACKERS] Optimizer Path Candidates difference in 9.1.3 and 9.2 beta1

Hi, hackersI 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

Re: [HACKERS] Optimizer Path Candidates difference in 9.1.3 and 9.2 beta1

Qi Huang huangq...@hotmail.com writes: Hi, hackersI 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

Re: [HACKERS] Optimizer Path Candidates difference in 9.1.3 and 9.2 beta1

[ shrug... ] When you're not showing us exactly what you did, it's hard to answer that for sure. But there is some prefiltering logic in joinpath.c that you might have to lobotomize too if you want to keep known-inferior join paths. regards, tom lane Thanks, Tom. Below is what I did for