Re: tsearch query plan

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