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

2012-06-26 Thread Qi Huang
> [ 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

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

2012-06-26 Thread Tom Lane
Qi Huang 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 four-relation query. In 9.1.

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

2012-06-26 Thread Qi Huang
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 of