pgsql: Improve speed of contrib/postgres_fdw regression tests.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve speed of contrib/postgres_fdw regression tests.
Date: 2017-01-25 13:31:39
Message-ID: E1cWNfn-00008c-EZ@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Improve speed of contrib/postgres_fdw regression tests.

Commit 7012b132d added some tests that consumed an excessive amount of
time, more than tripling the time needed for "make installcheck" for this
module. Add filter conditions to reduce the number of rows scanned,
bringing the runtime down to within hailing distance of what it was before.

Jeevan Chalke and Ashutosh Bapat, per a gripe from me

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

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/aa7f593b1ffa9717bd5570174944c06c482d1c1f

Modified Files
--------------
contrib/postgres_fdw/expected/postgres_fdw.out | 36 +++++++++++---------------
contrib/postgres_fdw/sql/postgres_fdw.sql | 12 ++++-----
2 files changed, 21 insertions(+), 27 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2017-01-25 14:00:03 pgsql: doc: Update ALTER SEQUENCE documentation to match
Previous Message Robert Haas 2017-01-25 03:03:03 pgsql: Be more aggressive in avoiding tuple conversion.