"Scott Marlowe" <[EMAIL PROTECTED]> writes: > On Mon, Jun 2, 2008 at 3:43 PM, Justin <[EMAIL PROTECTED]> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
