Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Committers > pgsql: Improve ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 16622 of 18152
Post > Topic >>

pgsql: Improve planner's estimation of the size of an append relation:

by tgl@[EMAIL PROTECTED] (Tom Lane) Jun 27, 2008 at 03:56 AM

Log Message:
-----------
Improve planner's estimation of the size of an append relation: rather
than
taking the maximum of any child rel's width, we should weight the widths
pro****tionally to the number of rows expected from each child.  In
hindsight
this is obviously correct because row width is really a proxy for the
total
physical size of the relation.  Per discussion with Scott Carey (bug
#4264).

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        allpaths.c (r1.170 -> r1.171)
       
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/allpaths.c?r1=1.170&r2=1.171)
    pgsql/src/backend/optimizer/plan:
        createplan.c (r1.240 -> r1.241)
       
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/plan/createplan.c?r1=1.240&r2=1.241)

-- 
Sent via pgsql-committers mailing list (pgsql-committers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers
 




 1 Posts in Topic:
pgsql: Improve planner's estimation of the size of an append rel
tgl@[EMAIL PROTECTED] (T  2008-06-27 03:56:55 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 1:08:58 CST 2008.