projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e634132) | patch
Fix unstable aggregate regression test
authorDavid Rowley <drowley@postgresql.org>
Wed, 27 Mar 2024 11:13:48 +0000 (00:13 +1300)
committerDavid Rowley <drowley@postgresql.org>
Wed, 27 Mar 2024 11:13:48 +0000 (00:13 +1300)
commitd6a6957d53e3de9982b076b6ddd703be3d0ae30a
treeb9daba9c54f6345864acbc03425972fdc4da5f01tree
parente6341323a8da64b18e9af3e75a4578230702d61ccommit | diff
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 diff | blob | blame | history
src/test/regress/sql/aggregates.sql diff | blob | blame | history
This is the main PostgreSQL git repository.