From 9bf559dee3b84e0ed3ab26c0b133fb2035c9312d Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 28 Jan 2007 03:02:31 +0000 Subject: 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/sql/stats.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'src/test/regress/sql/stats.sql') 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, -- cgit v1.2.1