[PATCHES] pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.)

[Thomas F. O'Connell]

I created a version of this a while back for a comparison of 7.4.x to 8.0.x. Now that 8.1.x has come out, I've decided to go ahead and put it in patch form for potential inclusion in contrib.

I only patched the English README.



The following patch is against a fresh pull from anonymous CVS.

The main addition is the addition of a -x option that allows specification of a number of successive runs of pgbench for use in sanity-checking basic benchmark results to reduce the potential for noise in a single run. At the end of a series of runs, the mean tps and standard deviations are reported. I didn't test compatibility with the new file code, but a cursory glance at the code makes me think it would work.

pgbench.patch
Description: Binary data

http://www.sitening.com/tools/postgresql-benchmark/

--
Thomas F. O'Connell
Database Architecture and Programming
Co-Founder
Sitening, LLC

http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Similar versions of pgbench.c for 7.4.7 and 8.0.2 are available at the following URL, although the argument was -m originally. I changed it to -x to follow bonnie++, which I frequently use in conjunction with pgbench for benchmarking.