]> granicus.if.org Git - postgresql/commit
Make psql_crosstab plans more stable
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 7 Jun 2016 23:18:31 +0000 (19:18 -0400)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Tue, 7 Jun 2016 23:18:31 +0000 (19:18 -0400)
commitc588df9971f41210d2fad8bf0112a78458de96cb
tree6455f143e87dfa8f5142bd54cf85ce6ad18d34ae
parent736c95ca1647ae088c4c996218e8ef20a56b1795
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
src/test/regress/sql/psql_crosstab.sql