From 9bf559dee3b84e0ed3ab26c0b133fb2035c9312d Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 28 Jan 2007 03:02:31 +0000 Subject: [PATCH] Add a delay at the start of the stats test, to let any prior stats activity quiesce. Possibly this will fix the large increase in non-reproducible stats test failures we've noted since turning on stats_row_level by default. --- src/test/regress/expected/stats.out | 8 ++++++++ src/test/regress/sql/stats.sql | 4 ++++ 2 files changed, 12 insertions(+) diff --git a/src/test/regress/expected/stats.out b/src/test/regress/expected/stats.out index d3495ffb48..66d655a24f 100644 --- a/src/test/regress/expected/stats.out +++ b/src/test/regress/expected/stats.out @@ -11,6 +11,14 @@ SHOW stats_start_collector; -- must be on on (1 row) +-- wait to let any prior tests finish dumping out stats; +-- else our messages might get lost due to contention +SELECT pg_sleep(2.0); + pg_sleep +---------- + +(1 row) + -- save counters CREATE TEMP TABLE prevstats AS SELECT t.seq_scan, t.seq_tup_read, t.idx_scan, t.idx_tup_fetch, diff --git a/src/test/regress/sql/stats.sql b/src/test/regress/sql/stats.sql index 75acee647d..412e94b516 100644 --- a/src/test/regress/sql/stats.sql +++ b/src/test/regress/sql/stats.sql @@ -8,6 +8,10 @@ -- conditio sine qua non SHOW stats_start_collector; -- must be on +-- wait to let any prior tests finish dumping out stats; +-- else our messages might get lost due to contention +SELECT pg_sleep(2.0); + -- save counters CREATE TEMP TABLE prevstats AS SELECT t.seq_scan, t.seq_tup_read, t.idx_scan, t.idx_tup_fetch, -- 2.11.0