"Scott Marlowe" <scott.marlowe@xxxxxxxxx> writes: > On Mon, Jun 2, 2008 at 3:43 PM, Justin <justin@xxxxxxxxxxxxxxx> wrote: >> >> I have noticed that estimated Cost to do the query is way off from Actual. > > Well, they're not measured in the same units. estimated costs are in > terms of the cost to sequentially scan a single tuple, while actual > costs are in milliseconds. s/tuple/page/ -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning
