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)
commit9ed05ef17226c4178d69eba7a7eed13d722c97f4
tree26bde1739eb67e9f09d1fbb188565ddb3bf7594d
parente564b18ebc66bc93a9b12fc9416ecbdc81fbc843
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