]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f95b533) | 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)
commit2c2161a47d4765842868b019bb1814495863127c
tree460f24fa38eef370db06c7623e34612f769b7ab1tree | snapshot
parentf95b5334a759c9e225a6c8e701899c5cd601541acommit | 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 | history
src/backend/optimizer/plan/createplan.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.