pgsql: Add ANALYZE into regression tests

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема pgsql: Add ANALYZE into regression tests
Дата
Msg-id E1WZCFS-0006Dy-GB@gemulon.postgresql.org
обсуждение исходный текст
Ответы Re: pgsql: Add ANALYZE into regression tests  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-committers
Add ANALYZE into regression tests

Looks like we can end up with different plans happening on the
buildfarm, which breaks the regression tests when we include
EXPLAIN output (which is done in the regression tests for
updatable security views, to ensure that the user-defined
function isn't pushed down to a level where it could view the
rows before the security quals are applied).

This adds in ANALYZE to hopefully make the plans consistent.
The ANALYZE ends up changing the original plan too, so the
update looks bigger than it really is.  The new plan looks
perfectly valid, of course.

Branch
------
master

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

Modified Files
--------------
src/test/regress/expected/updatable_views.out |  232 +++++++++++--------------
src/test/regress/sql/updatable_views.sql      |    4 +
2 files changed, 102 insertions(+), 134 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: pgsql: Make security barrier views automatically updatable
Следующее
От: Stephen Frost
Дата:
Сообщение: pgsql: Make a dedicated AlterTblSpcStmt production