Re: pgsql: Attempt to fix unstable regression tests, take 2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: David Rowley <dgrowley(at)gmail(dot)com>, David Rowley <drowley(at)postgresql(dot)org>, pgsql-committers(at)lists(dot)postgresql(dot)org, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Subject: Re: pgsql: Attempt to fix unstable regression tests, take 2
Date: 2020-04-01 00:40:59
Message-ID: 9629.1585701659@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

David Rowley <dgrowleyml(at)gmail(dot)com> writes:
> Can you share which failure you're talking about here? All of the
> ones I've looked at were failing post-ANALYZE.

It's what I posted yesterday:

diff -U3 /usr/home/tgl/pgsql/src/test/regress/expected/stats_ext.out /usr/home/tgl/pgsql/src/test/regress/results/stats_ext.out
--- /usr/home/tgl/pgsql/src/test/regress/expected/stats_ext.out 2020-03-30 21:15:19.749874000 -0400
+++ /usr/home/tgl/pgsql/src/test/regress/results/stats_ext.out 2020-03-30 22:29:04.062103000 -0400
@@ -1172,7 +1172,7 @@
SELECT * FROM check_estimated_rows('SELECT * FROM mcv_lists WHERE a = 1 AND b = ''1''');
estimated | actual
-----------+--------
- 1 | 50
+ 50 | 50
(1 row)

VACUUM (ANALYZE) mcv_lists;

That was with stats_ext as of f01157e2ac8ac4dff8ba159c36edf2fdb7d6704e.

regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2020-04-01 02:13:11 pgsql: Add -c/--restore-target-wal to pg_rewind
Previous Message David Rowley 2020-04-01 00:33:33 Re: pgsql: Attempt to fix unstable regression tests, take 2