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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/