diff options
author | Michael Paquier <michael@paquier.xyz> | 2021-04-02 09:44:54 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2021-04-02 09:44:54 +0900 |
commit | bada6280f0b98765ecad8d85063cddf6ce82b3b0 (patch) | |
tree | 95bb4b7f56e255ef7a2e67d61958489725331234 /src/backend/utils/adt/geo_spgist.c | |
parent | 84c5e0dd2e7344d36d5c3a32228b35a284ef1a1a (diff) | |
download | postgresql-bada6280f0b98765ecad8d85063cddf6ce82b3b0.tar.gz postgresql-bada6280f0b98765ecad8d85063cddf6ce82b3b0.zip |
Improve stability of test with vacuum_truncate in reloptions.sql
This test has been using a simple VACUUM with pg_relation_size() to
check if a relation gets physically truncated or not, but forgot the
fact that some concurrent activity, like checkpoint buffer writes, could
cause some pages to be skipped. The second test enabling
vacuum_truncate could fail, seeing a non-empty relation. The first test
would not have failed, but could finish by testing a behavior different
than the one aimed for. Both tests gain a FREEZE option, to make the
vacuums more aggressive and prevent page skips.
This is similar to the issues fixed in c2dc1a7.
Author: Arseny Sher
Reviewed-by: Masahiko Sawada
Discussion: https://postgr.es/m/87tuotr2hh.fsf@ars-thinkpad
backpatch-through: 12
Diffstat (limited to 'src/backend/utils/adt/geo_spgist.c')
0 files changed, 0 insertions, 0 deletions