diff options
| -rw-r--r-- | src/test/regress/expected/psql_crosstab.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/psql_crosstab.sql | 3 |
2 files changed, 5 insertions, 0 deletions
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 |