]> granicus.if.org Git - postgresql/commit
Tweak planner to use a minimum size estimate of 10 pages for a
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 24 Mar 2005 19:15:11 +0000 (19:15 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 24 Mar 2005 19:15:11 +0000 (19:15 +0000)
commitb741e9d4199e03b40c68c6a6a2ac935fb09d983a
treedf27be4ba6f51a11c48092bef4bc6fad7b9b7fd4
parentdd0702a399ba1e1a8fe82bb7b42473b499523349
Tweak planner to use a minimum size estimate of 10 pages for a
never-yet-vacuumed relation.  This restores the pre-8.0 behavior of
avoiding seqscans during initial data loading, while still allowing
reasonable optimization after a table has been vacuumed.  Several
regression test cases revert to 7.4-like behavior, which is probably
a good sign.  Per gripes from Keith Browne and others.
src/backend/optimizer/util/plancat.c
src/test/regress/expected/join.out
src/test/regress/expected/polymorphism.out
src/test/regress/expected/rules.out