Re: Are cost estimates based on asserts? - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Are cost estimates based on asserts?
Date
Msg-id s34d54c3.010@gwmta.wicourts.gov
Whole thread Raw
In response to Are cost estimates based on asserts?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Comments on columns in the pg_catalog tables/views
Next
From: "Kevin Grittner"
Date:
Subject: A costing analysis tool