• Tom Lane's avatar
    Tweak placement of explicit ANALYZE commands in the regression tests. · b5e0a2a3
    Tom Lane authored
    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.
    b5e0a2a3
aggregates.out 36.4 KB