Re: planner/optimizer question

On Apr 30, 2004, at 3:01 AM, Gary Doades wrote:

[ pg query plan, etc ]

I wonder if other parts of the plan are affecting the speed.

I've recently run into a case where a merge join plan was chosen for
this query, which took 11 seconds to execute. Forcing it to pick a
nested loop join dropped it to 3. (Updating my
default_statistics_target to 500 caused the planner to choose nested
loop join)

So, is the plan really the same?

A better comparision query may be a simple "select a from mytable
where a between foo and bar" to get an index scan. In that case its a
straight up, vanilla index scan. Nothing else getting in the way.

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/