| From: | ljguo_1234 <ljguo_1234(at)sina(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | abou the cost estimation |
| Date: | 2002-09-06 08:09:59 |
| Message-ID: | 20020906080959.19358.qmail@sina.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello, All
I have read the source code /cvsroot/pgsql/src/backend/optimizer/path/costsize.c and there is a function cost_sort(...). I think the code in 464 to 465 lines must be changed to:
startup_cost += npageaccesses *
(1.0 + cost_nonsequential_access(1)) * 0.5;
The original code is:
startup_cost += npageaccesses *
(1.0 + cost_nonsequential_access(npages)) * 0.5;
Can any one discuss about this issue with me ? Thanks for your response very much!
----------------------
Guo long jiang. 2002-9-6
______________________________________
===================================================================
(http://mail.sina.com.cn)
(http://classad.sina.com.cn/2shou/)
(http://sms.sina.com.cn/cgi-bin/sms/smspic.cgi)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hannu Krosing | 2002-09-06 08:21:52 | Re: Inheritance |
| Previous Message | Curt Sampson | 2002-09-06 07:53:12 | Re: Inheritance |