DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type
	:content-transfer-encoding:content-disposition;
	b=FleHL4rOPKz3q8EhVQJeBa5lw6E2nygfXureNj4/kKM7lfrWCT6DGIdMZAmtvuU2Xe
	w5OeeW5c9KQBTY72LeOMfV/Vcu27ljxQsWkD46/igb7a6dJUqvyiXzmcJt/Wq3s8bwp+
	z69whxMXnyWM/DDbPjM8eki5GYyT3RqJVBhtA=
Message-ID: <fd145f7d0807071405t1bdf4be0j8583fc9965a7719e@mail.gmail.com>
Date: Mon, 7 Jul 2008 14:05:37 -0700
From: "Jeffrey Baker" <jwbaker@gmail.com>
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Practical upper limits of pgbench read/write tps with 8.3
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I'm spending a third day testing with the ioDrive, and it occurred to
me that I should normalize my tests by mounting the database on a
ramdisk.  The results were surprisingly low.  On the single 2.2GHz
Athlon, the maximum tps seems to be 1450.  This is achieved with a
single connection.  I/O rates to and from the ramdisk never exceed
50MB/s on a one-minute average.

With the flash device on the same benchmark, the tps rate is 1350,
meaning that as far as PostgreSQL is concerned, on this machine, the
flash device achieves 90% of the best possible performance.

Question being: what's the bottleneck?  Is PG lock-bound?

-jwb