projects / users / simon / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: fca9ce1) | patch
Improve planner's estimation of the size of an append relation: rather than
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Jun 2008 03:56:55 +0000 (03:56 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Jun 2008 03:56:55 +0000 (03:56 +0000)
commit593fa6b9ee74f3179687859702c5e7e44d539939
tree0b01e55d18bce05d5eb667cbc1bc7133fe90b336tree
parentfca9ce1d528419a872696ece572fd7d488c64a5ccommit | diff
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).
src/backend/optimizer/path/allpaths.c diff | blob | blame | history
src/backend/optimizer/plan/createplan.c diff | blob | blame | history
Simon's dev repository