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

Поиск
Список
Период
Сортировка
От Thomas F. O'Connell
Тема Re: pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.)
Дата
Msg-id B03496C7-20D9-484A-B99F-FA22913967A7@sitening.com
обсуждение исходный текст
Ответ на pgbench: Support Multiple Simultaneous Runs (with Mean and Std. Dev.)  ("Thomas F. O'Connell" <tfo@sitening.com>)
Список 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 по дате отправления:

Предыдущее
От: "P. Scott DeVos"
Дата:
Сообщение: plpython tracebacks
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [INTERFACES] [BUGS] BUG #2171: Differences compiling plpgsql in