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.

At the end of a series of runs, the mean tps and standard deviations
are reported.

I only patched the English README.

I didn't test compatibility with the new file code, but a cursory
glance at the code makes me think it would work.

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



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.

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

"Thomas F. O'Connell" <tfo@sitening.com> writes:
> 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.

What exactly does this do that increasing the number of transactions
doesn't do?

Not to say that I'm not all for making pgbench results more trustworthy.
But adding still another parameter that people don't know what to do
with isn't going to create any progress in that direction.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings