This is a discussion on startup cost estimate within the pgsql Admins forums, part of the PostgreSQL category; --> Hi , How is the startup cost estimated in postgresql . Can u give me an example with necessary ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi , How is the startup cost estimated in postgresql . Can u give me an example with necessary calculations . thanks . --------------------------------- Sponsored Link Mortgage rates as low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms |
| ||||
| 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 jim@nasby.net 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 |
| Thread Tools | |
| Display Modes | |
|
|