postgres.git / summary / log / commit / refs

commit    f5d0e866404a249d3a87a016e3ec562ab2dc6706
Author:   David Rowley <drowley@postgresql.org>
Date:     Wed Mar 27 11:14:17 2024 +0000
First released in: 17.0, 16.3

    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.


 src/test/regress/expected/aggregates.out | 2 +-
 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 f635c5a1afb..68fd716d3e6 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 cc8f0efad55..758ad906516 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;


[parent: 7445f092814d]