> 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

Reply via email to