postgres.git / summary / log / commit / refs

commit    c588df9971f41210d2fad8bf0112a78458de96cb
Author:   Alvaro Herrera <alvherre@alvh.no-ip.org>
Date:     Tue Jun 07 23:18:31 2016 +0000

    Make psql_crosstab plans more stable
    
    To achieve this, ANALYZE the data table before querying it, as suggested
    by Tom Lane.  On my system, this enables the test to pass with 128 kB of
    work_mem (a value with which other tests fail -- so it seems good
    enough).
    
    Reported by Michaël Paquier.


 src/test/regress/expected/psql_crosstab.out | 2 ++
 src/test/regress/sql/psql_crosstab.sql      | 3 +++
 2 files changed, 5 insertions(+)

diff --git a/src/test/regress/expected/psql_crosstab.out b/src/test/regress/expected/psql_crosstab.out
index a9c20a179b3..f45e7261326 100644
--- a/src/test/regress/expected/psql_crosstab.out
+++ b/src/test/regress/expected/psql_crosstab.out
@@ -10,6 +10,8 @@ VALUES
    ('v0','h4','dbl', -3, '2014-12-15'),
    ('v0',NULL,'qux', 5, '2014-07-15'),
    ('v1','h2','quux',7, '2015-04-04');
+-- make plans more stable
+ANALYZE ctv_data;
 -- running \crosstabview after query uses query in buffer
 SELECT v, EXTRACT(year FROM d), count(*)
  FROM ctv_data
diff --git a/src/test/regress/sql/psql_crosstab.sql b/src/test/regress/sql/psql_crosstab.sql
index 43c959b7209..dff023876bf 100644
--- a/src/test/regress/sql/psql_crosstab.sql
+++ b/src/test/regress/sql/psql_crosstab.sql
@@ -12,6 +12,9 @@ VALUES
    ('v0',NULL,'qux', 5, '2014-07-15'),
    ('v1','h2','quux',7, '2015-04-04');
 
+-- make plans more stable
+ANALYZE ctv_data;
+
 -- running \crosstabview after query uses query in buffer
 SELECT v, EXTRACT(year FROM d), count(*)
  FROM ctv_data


[parent: 736c95ca1647]