pgsql: Fix unstable aggregate regression test

Поиск
Список
Период
Сортировка
От David Rowley
Тема pgsql: Fix unstable aggregate regression test
Дата
Msg-id E1rpREq-005vI7-96@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix unstable aggregate regression test

Buildfarm member avocet has shown a plan change by switching the
finalize aggregate stage to use a GroupAggregate rather than a
HashAggregate.  This is consistent with autovacuum having triggered on
the table, per analysis by Alexander Lakhin.

Fix this by disabling autovacuum on the table.

Reported-by: Alexander Lakhin
Discussion: https://postgr.es/m/d4493a28-589a-5328-fed5-250f2d7d3e2a@gmail.com
Backpatch-through: 16, where this test was added.

Branch
------
REL_16_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/f5d0e866404a249d3a87a016e3ec562ab2dc6706

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


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

Предыдущее
От: David Rowley
Дата:
Сообщение: pgsql: Fix unstable aggregate regression test
Следующее
От: Robert Haas
Дата:
Сообщение: pgsql: Rename COMPAT_OPTIONS_CLIENT to COMPAT_OPTIONS_OTHER.