Mark, > I've got one question about query planning. Is it understandable to > have the query plan estimation be off by a couple of orders of > magnitude? Or, is it the fact that the cost estimation is small to > begin with that the error between the actual and the estimated is > "normal"?
Well, your example is not "a couple orders of magnitude". 6 vs. 32 is actually pretty good accuracy. Now, 6 vs 192 would potentially be a problem, let alone 32 vs 13,471. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
