| From: | "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com> |
|---|---|
| To: | PgSQL - Patches <pgsql-patches(at)postgresql(dot)org> |
| Subject: | Re: pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.) |
| Date: | 2006-02-06 23:56:45 |
| Message-ID: | B03496C7-20D9-484A-B99F-FA22913967A7@sitening.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-02-07 01:40:18 | Re: [BUGS] BUG #2171: Differences compiling plpgsql in |
| Previous Message | P. Scott DeVos | 2006-02-06 22:05:37 | plpython tracebacks |