pgsql: Reduce duration of stats_ext regression tests

From: Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Reduce duration of stats_ext regression tests
Date: 2021-03-27 00:14:05
Message-ID: E1lPwab-00034Y-W6@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Reduce duration of stats_ext regression tests

The regression tests of extended statistics were taking a fair amount of
time, due to using fairly large data sets with a couple thousand rows.
So far this was fine, but with tests for statistics on expressions the
duration would get a bit excessive. So reduce the size of some of the
tests that will be used to test expressions, to keep the duration under
control. Done in a separate commit before adding the statistics on
expressions, to make it clear which estimates are expected to change.

Author: Tomas Vondra
Discussion: https://postgr.es/m/ad7891d2-e90c-b446-9fe2-7419143847d7%40enterprisedb.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/98376c18f12e562421b5c77e619248e8b7aae3c6

Modified Files
--------------
src/test/regress/expected/stats_ext.out | 42 ++++++++++++++++-----------------
src/test/regress/sql/stats_ext.sql | 8 +++----
2 files changed, 25 insertions(+), 25 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tomas Vondra 2021-03-27 00:14:06 pgsql: Extended statistics on expressions
Previous Message Tomas Vondra 2021-03-26 22:00:15 pgsql: Fix ndistinct estimates with system attributes