]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 7445f09) | patch
Fix unstable aggregate regression test
authorDavid Rowley <drowley@postgresql.org>
Wed, 27 Mar 2024 11:14:17 +0000 (00:14 +1300)
committerDavid Rowley <drowley@postgresql.org>
Wed, 27 Mar 2024 11:14:17 +0000 (00:14 +1300)
commitf5d0e866404a249d3a87a016e3ec562ab2dc6706
tree9cb1023e3bb7db7c119588d241bb10dc3a0e9a97tree | snapshot
parent7445f092814dbb8ac3061524fc341a209f805d80commit | 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
Mirror of https://git.postgresql.org/git/postgresql.git