X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6B07553A62 for ; Tue, 29 Mar 2005 13:17:13 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 21493-08 for ; Tue, 29 Mar 2005 12:17:08 +0000 (GMT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id 83D9653459 for ; Tue, 29 Mar 2005 13:17:07 +0100 (BST) Received: (qmail 23039 invoked from network); 29 Mar 2005 12:16:00 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.36?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 29 Mar 2005 12:16:00 -0000 Message-ID: <42494741.7060806@fastcrypt.com> Date: Tue, 29 Mar 2005 07:17:05 -0500 From: Dave Cramer Reply-To: pg@fastcrypt.com Organization: Postgres International User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-performance@postgresql.org Subject: Re: How to improve db performance with $7K? References: <42443863.4040302@sfnet.cc> <4244A90B.2030200@sfnet.cc> <42453273.2060509@turtle-entertainment.de> <200503261255.59007.josh@agliodbs.com> <42455DEC.2080301@sfnet.cc> <1112049794.23284.29.camel@localhost.localdomain> <424840AE.3050200@sfnet.cc> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.034 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/626 X-Sequence-Number: 11331 Yeah, 35Mb per sec is slow for a raid controller, the 3ware mirrored is about 50Mb/sec, and striped is about 100 Dave PFC wrote: > >> With hardware tuning, I am sure we can do better than 35Mb per sec. Also > > > WTF ? > > My Laptop does 19 MB/s (reading <10 KB files, reiser4) ! > > A recent desktop 7200rpm IDE drive > # hdparm -t /dev/hdc1 > /dev/hdc1: > Timing buffered disk reads: 148 MB in 3.02 seconds = 49.01 MB/sec > > # ll "DragonBall 001.avi" > -r--r--r-- 1 peufeu users 218M mar 9 20:07 DragonBall > 001.avi > > # time cat "DragonBall 001.avi" >/dev/null > real 0m4.162s > user 0m0.020s > sys 0m0.510s > > (the file was not in the cache) > => about 52 MB/s (reiser3.6) > > So, you have a problem with your hardware... > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > > -- Dave Cramer http://www.postgresintl.com 519 939 0336 ICQ#14675561