On Nov 18, 2006, at 3:15 AM, rakesh kumar wrote:
How is the startup cost estimated in postgresql . Can u
give me an example with necessary calculations .
thanks .
Assuming you're talking about estimates from EXPLAIN/EXPLAIN ANALYZE,
the startup cost is the estimate of how much work it will take to
generate the first row from an operation.
--
Jim Nasby [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
