Horton

Fix unstable aggregate regression test

David Rowley <drowley@postgresql.org>

View on postgr.es
Commit: f5d0e866404a249d3a87a016e3ec562ab2dc6706
Author: David Rowley <drowley@postgresql.org>
Date: 2024-03-27T11:14:17Z
Releases: 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.

Files

PathChange+/−
src/test/regress/expected/aggregates.out modified +1 −1
src/test/regress/sql/aggregates.sql modified +1 −1

Discussion