At Mon, 06 Mar 2023 15:24:25 +0900 (JST), Kyotaro Horiguchi <horikyota....@gmail.com> wrote in > In any case, I think we need to avoid such concurrent autovacuum/analyze.
If it is correct, I believe the attached fix works. regads. -- Kyotaro Horiguchi NTT Open Source Software Center
diff --git a/src/test/regress/expected/stats.out b/src/test/regress/expected/stats.out index 937b2101b3..023ec5ecc4 100644 --- a/src/test/regress/expected/stats.out +++ b/src/test/regress/expected/stats.out @@ -1137,7 +1137,7 @@ SELECT pg_stat_get_subscription_stats(NULL); -- extends. SELECT sum(extends) AS io_sum_shared_before_extends FROM pg_stat_io WHERE io_context = 'normal' AND io_object = 'relation' \gset -CREATE TABLE test_io_shared(a int); +CREATE TABLE test_io_shared(a int) WITH (autovacuum_enabled = 'false'); INSERT INTO test_io_shared SELECT i FROM generate_series(1,100)i; SELECT pg_stat_force_next_flush(); pg_stat_force_next_flush diff --git a/src/test/regress/sql/stats.sql b/src/test/regress/sql/stats.sql index 74e592aa8a..aa6552befd 100644 --- a/src/test/regress/sql/stats.sql +++ b/src/test/regress/sql/stats.sql @@ -549,7 +549,7 @@ SELECT pg_stat_get_subscription_stats(NULL); -- extends. SELECT sum(extends) AS io_sum_shared_before_extends FROM pg_stat_io WHERE io_context = 'normal' AND io_object = 'relation' \gset -CREATE TABLE test_io_shared(a int); +CREATE TABLE test_io_shared(a int) WITH (autovacuum_enabled = 'false'); INSERT INTO test_io_shared SELECT i FROM generate_series(1,100)i; SELECT pg_stat_force_next_flush(); SELECT sum(extends) AS io_sum_shared_after_extends