pgsql: Still another try at stabilizing stats_ext test results.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Still another try at stabilizing stats_ext test results.
Date: 2020-03-31 20:09:41
Message-ID: E1jJNCf-00045H-5B@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Still another try at stabilizing stats_ext test results.

The stats_ext test is not expecting that autovacuum will touch
any of its tables; an expectation falsified by commit b07642dbc.
Although I'm suspicious that there's something else going on that
makes extended stats estimates not 100% reproducible, it's pretty
easy to demonstrate that there are places in this test that fail
if an autovacuum updates the table's stats unexpectedly.

Hence, revert the band-aid changes made by 2dc16efed and 24566b359
in favor of summarily disabling autovacuum for all the tables that
this test checks estimated rowcounts for.

Also remove an evidently obsolete comment at the head of the test.

Discussion: https://postgr.es/m/15012.1585623298@sss.pgh.pa.us

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0936d1b6ffc6d59b4d17f3d6e53c036110c02b44

Modified Files
--------------
src/test/regress/expected/stats_ext.out | 54 +++++++++++++++++++-------------
src/test/regress/sql/stats_ext.sql | 55 ++++++++++++++++++++-------------
2 files changed, 65 insertions(+), 44 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2020-03-31 20:31:52 pgsql: doc: adjust UPDATE/DELETE's FROM/USING to match SELECT's FROM
Previous Message Alvaro Herrera 2020-03-31 19:49:21 pgsql: Remove header noise from test_decoding test