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 1180B53410 for ; Tue, 29 Mar 2005 10:50:04 +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 77224-02 for ; Tue, 29 Mar 2005 09:49:58 +0000 (GMT) Received: from boutiquenumerique.com (unknown [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 939B453406 for ; Tue, 29 Mar 2005 10:49:54 +0100 (BST) Received: (qmail 17931 invoked from network); 29 Mar 2005 11:48:49 +0200 Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4) by boutiquenumerique.com with SMTP; 29 Mar 2005 11:48:49 +0200 Date: Tue, 29 Mar 2005 11:48:34 +0200 From: PFC To: "Steve Poe" , "Cott Lang" Subject: Re: How to improve db performance with $7K? Cc: pgsql-performance@postgresql.org 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> Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-ID: In-Reply-To: <4244A90B.2030200@sfnet.cc> User-Agent: Opera M2(BETA2)/8.0 (Linux, build 987) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/624 X-Sequence-Number: 11329 > 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...