Re: pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.)

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)

Browse pgsql-patches by date

  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