Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 452912E0100 for ; Mon, 17 Mar 2008 15:50:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 85399-03 for ; Mon, 17 Mar 2008 15:50:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.emproshunts.com (mail.emproshunts.com [66.64.191.19]) by postgresql.org (Postfix) with ESMTP id 7E2932E1A8C for ; Mon, 17 Mar 2008 15:39:30 -0300 (ADT) Received: from [192.168.1.40] by mail.emproshunts.com (GMS 15.00.3626/KX5895.00.ca7cb0e7) with ESMTP id xbsahaaa for pgsql-performance@postgresql.org; Mon, 17 Mar 2008 14:39:26 -0400 Message-ID: <47DEC8AB.8060608@emproshunts.com> Date: Mon, 17 Mar 2008 14:38:19 -0500 From: Justin User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: Craig James CC: Greg Smith , pgsql-performance@postgresql.org Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 References: <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> <47DA1866.3050500@krogh.cc> <47DA37E1.6050104@emproshunts.com> <47DA5852.30004@emproshunts.com> <47DCBBF9.1090401@emproshunts.com> <47DD6F4C.2050208@emolecules.com> <47DEBD7C.2060204@emproshunts.com> <47DEC2AD.8080602@emproshunts.com> <47DEB978.2030307@emolecules.com> In-Reply-To: <47DEB978.2030307@emolecules.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-DNSBL: 0 X-AntiSpam: Checked for restricted content by Gordano's AntiSpam Software X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/354 X-Sequence-Number: 29308 Craig James wrote: > 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 > it is a RAID 10 controller with 6 SAS 10K 73 gig drives. The server is 3 weeks old now. it has 16 gigs of RAM 2 quad core Xenon 1.88 Ghz processors 2 gig Ethernet cards. RAID controller perc 6/i with battery backup 512meg cache, setup not lie about fsync WAL is on a RAID 0 drive along with the OS