diff options
| author | Jeff Davis <jdavis@postgresql.org> | 2024-10-18 10:57:46 -0700 |
|---|---|---|
| committer | Jeff Davis <jdavis@postgresql.org> | 2024-10-18 10:57:46 -0700 |
| commit | 779972e534c05c51be3e593b0681029afb1bd155 (patch) | |
| tree | 3f58b48cc5ce87be41d936a8fc1cf4a36e76577a | |
| parent | b391d882ff38da423dc99fc6224bde4be4100212 (diff) | |
| download | postgresql-779972e534c05c51be3e593b0681029afb1bd155.tar.gz postgresql-779972e534c05c51be3e593b0681029afb1bd155.zip | |
Disable autovacuum for tables in stats import tests.
While we haven't observed any test instability, it seems like a good
idea to disable autovacuum during the stats import tests.
Author: Corey Huinker
Discussion: https://postgr.es/m/CADkLM=fajh1Lpcyr_XsMmq-9Z=SGk-u+_Zeac7Pt0RAN3uiVCg@mail.gmail.com
| -rw-r--r-- | src/test/regress/expected/stats_import.out | 5 | ||||
| -rw-r--r-- | src/test/regress/sql/stats_import.sql | 5 |
2 files changed, 6 insertions, 4 deletions
diff --git a/src/test/regress/expected/stats_import.out b/src/test/regress/expected/stats_import.out index 495e9b03485..a4e3a0f3c48 100644 --- a/src/test/regress/expected/stats_import.out +++ b/src/test/regress/expected/stats_import.out @@ -11,7 +11,7 @@ CREATE TABLE stats_import.test( comp stats_import.complex_type, arange int4range, tags text[] -); +) WITH (autovacuum_enabled = false); -- starting stats SELECT relpages, reltuples, relallvisible FROM pg_class @@ -139,7 +139,8 @@ DETAIL: This operation is not supported for views. CREATE TABLE stats_import.part_parent ( i integer ) PARTITION BY RANGE(i); CREATE TABLE stats_import.part_child_1 PARTITION OF stats_import.part_parent - FOR VALUES FROM (0) TO (10); + FOR VALUES FROM (0) TO (10) + WITH (autovacuum_enabled = false); ANALYZE stats_import.part_parent; SELECT relpages FROM pg_class diff --git a/src/test/regress/sql/stats_import.sql b/src/test/regress/sql/stats_import.sql index 108b0c45586..126b3ab9b9c 100644 --- a/src/test/regress/sql/stats_import.sql +++ b/src/test/regress/sql/stats_import.sql @@ -13,7 +13,7 @@ CREATE TABLE stats_import.test( comp stats_import.complex_type, arange int4range, tags text[] -); +) WITH (autovacuum_enabled = false); -- starting stats SELECT relpages, reltuples, relallvisible @@ -99,7 +99,8 @@ SELECT CREATE TABLE stats_import.part_parent ( i integer ) PARTITION BY RANGE(i); CREATE TABLE stats_import.part_child_1 PARTITION OF stats_import.part_parent - FOR VALUES FROM (0) TO (10); + FOR VALUES FROM (0) TO (10) + WITH (autovacuum_enabled = false); ANALYZE stats_import.part_parent; |