From: David Kerr <dmk@mr-paradox.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Simon Riggs <simon@2ndQuadrant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Question on pgbench output
Date: Sun, 05 Apr 2009 10:12:34 -0700
Message-ID: <49D8E682.9020601@mr-paradox.net> (raw)
In-Reply-To: <4665.1238946412@sss.pgh.pa.us>
References: <20090403195302.GA54342@mr-paradox.net>
<alpine.GSO.2.01.0904031721570.5502@westnet.com>
<24809.1238799146@sss.pgh.pa.us>
<20090403233458.GC54342@mr-paradox.net>
<1238914900.5444.292.camel@ebony.2ndQuadrant>
<4665.1238946412@sss.pgh.pa.us>
Tom Lane wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
>> On Fri, 2009-04-03 at 16:34 -0700, David Kerr wrote:
>>> 400 concurrent users doesn't mean that they're pulling 1.5 megs /
>>> second every second.
>
>> There's a world of difference between 400 connected and 400 concurrent
>> users. You've been testing 400 concurrent users, yet without measuring
>> data transfer. The think time will bring the number of users right down
>> again, but you really need to include the much higher than normal data
>> transfer into your measurements and pgbench won't help there.
>
> Actually pgbench can simulate think time perfectly well: use its \sleep
> command in your script. I think you can even set it up to randomize the
> sleep time.
>
> I agree that it seems David has been measuring a case far beyond what
> his real problem is.
>
> regards, tom lane
>
Fortunately the network throughput issue is not mine to solve.
Would it be fair to say that with the pgbench output i've given so far
that if all my users clicked "go" at the same time (i.e., worst case
scenario), i could expect (from the database) about 8 second response time?
Thanks
Dave Kerr
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dmk@mr-paradox.net, tgl@sss.pgh.pa.us, simon@2ndQuadrant.com
Subject: Re: Question on pgbench output
In-Reply-To: <49D8E682.9020601@mr-paradox.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox