]> granicus.if.org Git - postgresql/commit
Tweak placement of explicit ANALYZE commands in the regression tests.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 11 Dec 2013 20:08:33 +0000 (15:08 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 11 Dec 2013 20:09:15 +0000 (15:09 -0500)
commitb5e0a2a38401273d3d11b81f4424681db9845882
tree702e7e11c50a7a8c06b114f019e3f856141256fb
parent60dd40bbda92cb1818d5a2651b9d2ba49afd804c
Tweak placement of explicit ANALYZE commands in the regression tests.

Make the COPY test, which loads most of the large static tables used in
the tests, also explicitly ANALYZE those tables.  This allows us to get
rid of various ad-hoc, and rather redundant, ANALYZE commands that had
gotten stuck into various test scripts over time to ensure we got
consistent plan choices.  (We could have done a database-wide ANALYZE,
but that would cause stats to get attached to the small static tables
too, which results in plan changes compared to the historical behavior.
I'm not sure that's a good idea, so not going that far for now.)

Back-patch to 9.0, since 9.0 and 9.1 are currently sometimes failing
regression tests for lack of an "ANALYZE tenk1" in the subselect test.
There's no need for this in 8.4 since we didn't print any plans back
then.
12 files changed:
src/test/regress/expected/aggregates.out
src/test/regress/expected/alter_table.out
src/test/regress/expected/arrays.out
src/test/regress/expected/create_index.out
src/test/regress/expected/join.out
src/test/regress/input/copy.source
src/test/regress/output/copy.source
src/test/regress/sql/aggregates.sql
src/test/regress/sql/alter_table.sql
src/test/regress/sql/arrays.sql
src/test/regress/sql/create_index.sql
src/test/regress/sql/join.sql