diff options
| author | David Rowley <drowley@postgresql.org> | 2024-03-28 00:13:48 +1300 |
|---|---|---|
| committer | David Rowley <drowley@postgresql.org> | 2024-03-28 00:13:48 +1300 |
| commit | d6a6957d53e3de9982b076b6ddd703be3d0ae30a (patch) | |
| tree | b9daba9c54f6345864acbc03425972fdc4da5f01 | |
| parent | e6341323a8da64b18e9af3e75a4578230702d61c (diff) | |
| download | postgresql-d6a6957d53e3de9982b076b6ddd703be3d0ae30a.tar.gz postgresql-d6a6957d53e3de9982b076b6ddd703be3d0ae30a.zip | |
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.
| -rw-r--r-- | src/test/regress/expected/aggregates.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/aggregates.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/aggregates.out b/src/test/regress/expected/aggregates.out index d54a255e582..50695d83a2b 100644 --- a/src/test/regress/expected/aggregates.out +++ b/src/test/regress/expected/aggregates.out @@ -1930,7 +1930,7 @@ select string_agg(v, decode('ee', 'hex')) from bytea_test_table; drop table bytea_test_table; -- Test parallel string_agg and array_agg -create table pagg_test (x int, y int); +create table pagg_test (x int, y int) with (autovacuum_enabled = off); insert into pagg_test select (case x % 4 when 1 then null else x end), x % 10 from generate_series(1,5000) x; diff --git a/src/test/regress/sql/aggregates.sql b/src/test/regress/sql/aggregates.sql index 441e01d150c..2905848eadc 100644 --- a/src/test/regress/sql/aggregates.sql +++ b/src/test/regress/sql/aggregates.sql @@ -749,7 +749,7 @@ select string_agg(v, decode('ee', 'hex')) from bytea_test_table; drop table bytea_test_table; -- Test parallel string_agg and array_agg -create table pagg_test (x int, y int); +create table pagg_test (x int, y int) with (autovacuum_enabled = off); insert into pagg_test select (case x % 4 when 1 then null else x end), x % 10 from generate_series(1,5000) x; |