Unix Technical Forum

Re: Are cost estimates based on asserts?

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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-11-2008, 07:12 AM
Kevin Grittner
 
Posts: n/a
Default Re: Are cost estimates based on asserts?

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:12 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com