pgsql: Fix unstable aggregate regression test

Поиск
Список
Период
Сортировка
От David Rowley
Тема pgsql: Fix unstable aggregate regression test
Дата
Msg-id E1rpREP-005vHH-Pn@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
------
master

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

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 по дате отправления:

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: [MASSMAIL] pgsql: Add functions to generate random numbers in a specified range.
Следующее
От: David Rowley
Дата:
Сообщение: pgsql: Fix unstable aggregate regression test