]> git.ipfire.org Git - thirdparty/postgresql.git/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:14:49 +0000 (19:14 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 24 Mar 2005 19:14:49 +0000 (19:14 +0000)
commit208ec47ba33289d4c18b2ad2feb6a9e7b88c58c5
treef3baf6436376eb677bac60061047c7bc5b7ef2ea
parent7604267de88da39dc7d920ad8bdbf67cecf0feb8
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