[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.

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.

Advertising

I only patched the English README.



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

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.