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: | Raw Message | Whole Thread | 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 |