Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 9A8BE2E0092
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 17 Mar 2008 15:44:23 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 21542-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 17 Mar 2008 15:43:59 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from mail.emolecules.com (66-226-76-106.dedicated.abac.net
	[66.226.76.106])
	by postgresql.org (Postfix) with ESMTP id 549882E0D10
	for <pgsql-performance@postgresql.org>;
	Mon, 17 Mar 2008 15:33:36 -0300 (ADT)
Received: (qmail 6797 invoked by uid 2020); 17 Mar 2008 10:33:34 -0800
Received: from wsip-68-224-174-233.sd.sd.cox.net (HELO
	lisa-james-computer.local) (68.224.174.233)
	by 192.168.0.4 with SMTP; 17 Mar 2008 10:33:34 -0800
Message-ID: <47DEB978.2030307@emolecules.com>
Date: Mon, 17 Mar 2008 11:33:28 -0700
From: Craig James <craig_james@emolecules.com>
User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213)
MIME-Version: 1.0
To: Justin <justin@emproshunts.com>
CC: Greg Smith <gsmith@gregsmith.com>, pgsql-performance@postgresql.org
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
References: <f966c2ee0803052142l6a105678jfe2da92a0d9371@mail.gmail.com>
	<Pine.GSO.4.64.0803060813570.11897@westnet.com>
	<47D00DB2.7040007@emolecules.com> <18451.1204824562@sss.pgh.pa.us>
	<47D0AFC1.5070305@emolecules.com>
	<08115901408538@mail.emproshunts.com>
	<47D93A43.6020503@emolecules.com>
	<016301c8854e$851e06e0$3101a8c0@JDell>
	<dcc563d10803132312o1539215fk859bbae03f36e566@mail.gmail.com>
	<47DA1866.3050500@krogh.cc>
	<dcc563d10803132319u19480a4fn16115c415ee57844@mail.gmail.com>
	<47DA37E1.6050104@emproshunts.com>
	<Pine.GSO.4.64.0803140359220.20241@westnet.com>
	<47DA5852.30004@emproshunts.com> <47DCBBF9.1090401@emproshunts.com>
	<F38ADB71-8F77-41C8-9066-488FFCA7BD67@fastcrypt.com>
	<47DD6F4C.2050208@emolecules.com>
	<47DEBD7C.2060204@emproshunts.com>
	<B18EFFDB-D930-47AB-A0BF-2A4AAF1C4765@fastcrypt.com>
	<47DEC2AD.8080602@emproshunts.com>
In-Reply-To: <47DEC2AD.8080602@emproshunts.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200803/353
X-Sequence-Number: 29307

Justin wrote:
>> 2000 tps ??? do you have fsync turned off ?
>>
>> Dave
>>
> 
> No its turned on.

Unless I'm seriously confused, something is wrong with these numbers.  That's the sort of performance you expect from a good-sized RAID 10 six-disk array.  With a single 7200 rpm SATA disk and XFS, I get 640 tps.  There's no way you could 2000 tps from a single disk.

Craig