pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Kerr <dmk@mr-paradox.net>
Cc: Simon Riggs <simon@2ndQuadrant.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Question on pgbench output
Date: Sun, 05 Apr 2009 13:43:50 -0400
Message-ID: <16703.1238953430@sss.pgh.pa.us> (raw)
In-Reply-To: <49D8E682.9020601@mr-paradox.net>
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>
	<49D8E682.9020601@mr-paradox.net>

David Kerr <dmk@mr-paradox.net> writes:
> 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?

For the hardware you've got, and ignoring the network bandwidth issue,
that appears to be a fair estimate of the worst case response.

			regards, tom lane




view thread (15+ messages)

Message-ID: <16703.1238953430@sss.pgh.pa.us>
Permalink:  ../16703.1238953430@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/16703.1238953430@sss.pgh.pa.us

 · 

reply
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: tgl@sss.pgh.pa.us, dmk@mr-paradox.net, simon@2ndQuadrant.com
  Subject: Re: Question on pgbench output
  In-Reply-To: <16703.1238953430@sss.pgh.pa.us>

* 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