Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Improve planner's estimation of the size of an append relation: - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Improve planner's estimation of the size of an append relation:
Date
Msg-id 20080627035655.80207754857@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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
proportionally 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)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Mention actual function names in documentation of how to pass
Next
From: mkz@pgfoundry.org (User Mkz)
Date:
Subject: plproxy - plproxy: Scanner/parser portability changes.