diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2017-09-22 12:59:44 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2017-09-22 12:59:44 -0400 |
commit | 0f574a7afb5c998d19dc3d981e45cb10267286ed (patch) | |
tree | ae585922f256a8d809f5c87a0a4179140ff3f126 /src | |
parent | 5d3cad564729f64d972c5c803ff34f0eb40bfd0c (diff) | |
download | postgresql-0f574a7afb5c998d19dc3d981e45cb10267286ed.tar.gz postgresql-0f574a7afb5c998d19dc3d981e45cb10267286ed.zip |
Allow up to 3 "-P 1" reports per thread in pgbench run of 2 seconds.
There seems to be some considerable imprecision in the timing of -P
progress reports. Nominally each thread ought to produce 2 reports
in this test, but about 10% of the time we only get one, and 1% of
the time we get three, as per buildfarm results so far. Pending
further investigation, treat the last case as a "pass". (I, tgl,
am suspicious that this still might not be lax enough, now that it's
obvious that the behavior is load-dependent; but there's not yet
buildfarm evidence to confirm that suspicion.)
Fabien Coelho
Discussion: https://postgr.es/m/26654.1505232433@sss.pgh.pa.us
Diffstat (limited to 'src')
-rw-r--r-- | src/bin/pgbench/t/001_pgbench_with_server.pl | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/bin/pgbench/t/001_pgbench_with_server.pl b/src/bin/pgbench/t/001_pgbench_with_server.pl index 3609b9bedeb..7db4bc8c978 100644 --- a/src/bin/pgbench/t/001_pgbench_with_server.pl +++ b/src/bin/pgbench/t/001_pgbench_with_server.pl @@ -462,8 +462,9 @@ pgbench( [ qr{vacuum}, qr{progress: 1\b} ], 'pgbench progress'); -# $nthreads threads, 2 seconds, sometimes only one aggregated line is written -check_pgbench_logs('001_pgbench_log_1', $nthreads, 1, 2, +# $nthreads threads, 2 seconds, but due to timing imprecision we might get +# only 1 or as many as 3 progress reports per thread. +check_pgbench_logs('001_pgbench_log_1', $nthreads, 1, 3, qr{^\d+ \d{1,2} \d+ \d+ \d+ \d+ \d+ \d+ \d+ \d+ \d+$}); # with sampling rate |