pgsql: Temporarily instrument postgres_fdw test to look for statistics

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Temporarily instrument postgres_fdw test to look for statistics
Date: 2018-03-05 21:20:11
Message-ID: E1esxWl-0000D3-PP@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Temporarily instrument postgres_fdw test to look for statistics changes.

It seems fairly hard to explain recent buildfarm failures without the
theory that something is doing an ANALYZE behind our backs. Probe
for this directly to see if it's true.

In principle the outputs of these queries should be stable, since the table
in question is small enough that ANALYZE's sample will include all rows.
But even if that turns out to be wrong, we can put up with some failures
for a bit. I don't intend to leave this here indefinitely.

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c2c537c56dc30ec3cdc12051f4ea5363aa66d73c

Modified Files
--------------
contrib/postgres_fdw/expected/postgres_fdw.out | 31 ++++++++++++++++++++++++++
contrib/postgres_fdw/sql/postgres_fdw.sql | 13 +++++++++++
2 files changed, 44 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2018-03-05 22:39:01 pgsql: Clone extended stats in CREATE TABLE (LIKE INCLUDING ALL)
Previous Message Tom Lane 2018-03-05 20:37:45 pgsql: Add infrastructure to support server-version-dependent tab compl