This is a discussion on Re: Are cost estimates based on asserts? within the pgsql Hackers forums, part of the PostgreSQL category; --> Hmmm... Poorly phrased question on my part, I guess. When I saw that the cost estimates tracked so much ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hmmm... Poorly phrased question on my part, I guess. When I saw that the cost estimates tracked so much better with the actual execution time when the asserts were being evaluated, it got me wondering whether some significant part of the costing development and testing occured in that environment. I assume we care more about accurate costing in environments where asserts are not checked, although I hate to assume anything. If there is a chance that asserts affected costing calculations, it would give me a vague clue about where adjustments might be most useful. For a discussion about a better way to get clues, see my next post. -Kevin >>> Tom Lane <tgl@sss.pgh.pa.us> 10/12/05 5:15 PM >>> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes: > [$subject] No, the planner has no idea about the cost of Asserts. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |