Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 227686336E9 for ; Tue, 2 Mar 2010 19:00:34 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 64587-01 for ; Tue, 2 Mar 2010 23:00:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from madmax.bizintegrators.com (madmax.bizintegrators.com [64.94.184.54]) by mail.postgresql.org (Postfix) with ESMTP id A59E763F416 for ; Tue, 2 Mar 2010 18:26:57 -0400 (AST) Received: from shelca (p65-147.acedsl.com [66.114.65.147]) (authenticated bits=0) by madmax.bizintegrators.com (8.13.4/8.13.4) with ESMTP id o22MQmCl018714 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 2 Mar 2010 17:26:48 -0500 (EST) References: Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: david@lang.hm Cc: Scott Marlowe , Pgsql performance Subject: Re: 10K vs 15k rpm for analytics Date: Tue, 02 Mar 2010 17:26:54 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit X-Loftmail-Check: No X-Scanned-By: MIMEDefang 2.57 on 64.94.184.88 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.74 tagged_above=-10 required=5 tests=BAYES_20=-0.74 X-Spam-Level: X-Archive-Number: 201003/39 X-Sequence-Number: 37864 david@lang.hm writes: > what filesystem is being used. There is a thread on the linux-kernel > mailing list right now showing that ext4 seems to top out at ~360MB/sec > while XFS is able to go to 500MB/sec+ EXT3 on Centos 5.4 Plan to try and see if I have time with the new machines to try FreeBSD+ZFS. ZFS supposedly makes good use of memory and the new machines will have 72GB of RAM.