Revision 52c342dd0241f18c16975da309585cfbc69e36d3 authored by Tom Lane on 11 December 2013, 20:08:42 UTC, committed by Tom Lane on 11 December 2013, 20:08:42 UTC
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.
1 parent 48e5cfd
History
File Mode Size
config
contrib
doc
src
.gitignore -rw-r--r-- 360 bytes
COPYRIGHT -rw-r--r-- 1.2 KB
GNUmakefile.in -rw-r--r-- 3.7 KB
Makefile -rw-r--r-- 1.5 KB
README -rw-r--r-- 1.3 KB
README.git -rw-r--r-- 816 bytes
aclocal.m4 -rw-r--r-- 385 bytes
configure -rwxr-xr-x 850.2 KB
configure.in -rw-r--r-- 62.7 KB

README

back to top