Re: pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.) - Mailing list pgsql-patches

From Thomas F. O'Connell
Subject Re: pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.)
Date
Msg-id B03496C7-20D9-484A-B99F-FA22913967A7@sitening.com
Whole thread Raw
In response to pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.)  ("Thomas F. O'Connell" <tfo@sitening.com>)
List pgsql-patches
Tom,

I noticed in this thread:

http://archives.postgresql.org/pgsql-performance/2005-12/msg00206.php

you state:

"Try something like "-s 10 -c 10 -t 3000" to get numbers reflecting test
conditions more like what the TPC council had in mind when they designed
this benchmark.  I tend to repeat such a test 3 times to see if the
numbers are repeatable, and quote the middle TPS number as long as
they're not too far apart."

The -x I added is to make your "3 times" easier. Sure, it's just
sugar, but if this is part of the recommended use of the tool, or
even a personal case study from the core team, I figured it might be
of use to others. Anyway, just a followup since I was going through
the archives and found a mild argument in favor it from you. :)

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

http://www.sitening.com/
3004 B Poston Avenue
Nashville, TN 37203-1314
615-260-0005 (cell)
615-469-5150 (office)
615-469-5151 (fax)


pgsql-patches by date:

Previous
From: "P. Scott DeVos"
Date:
Subject: plpython tracebacks
Next
From: Bruce Momjian
Date:
Subject: Re: [INTERFACES] [BUGS] BUG #2171: Differences compiling plpgsql in