Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0B921636071 for ; Tue, 9 Mar 2010 11:48:11 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 21831-05-6 for ; Tue, 9 Mar 2010 15:47:50 +0000 (UTC) X-Greylist: delayed 01:00:09.461966 by SQLgrey-1.7.6 Received: from vms173007pub.verizon.net (vms173007pub.verizon.net [206.46.173.7]) by mail.postgresql.org (Postfix) with ESMTP id C6BC26342B1 for ; Tue, 9 Mar 2010 11:47:28 -0400 (AST) Received: from osgiliath.mathom.us ([unknown] [72.83.250.27]) by vms173007.mailsrvcs.net (Sun Java(tm) System Messaging Server 7u2-7.02 32bit (built Apr 16 2009)) with ESMTPA id <0KZ0008RSRQPJ241@vms173007.mailsrvcs.net> for pgsql-performance@postgresql.org; Tue, 09 Mar 2010 08:47:18 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id 96D906F7B8 for ; Tue, 09 Mar 2010 09:47:12 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at mathom.us Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath.home.mathom.us [127.0.0.1]) (amavisd-new, port 10024) with LMTP id J2A+xOWrv2YH for ; Tue, 09 Mar 2010 09:47:12 -0500 (EST) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 49DF338299; Tue, 09 Mar 2010 09:47:12 -0500 (EST) Date: Tue, 09 Mar 2010 09:47:12 -0500 From: Michael Stone To: pgsql-performance@postgresql.org Subject: Re: 10K vs 15k rpm for analytics Message-id: <77d4f126-2b8a-11df-9b6a-001cc0cda50c@msgid.mathom.us> Mail-followup-to: pgsql-performance@postgresql.org References: <06A22EB5-2D84-401C-B75F-7CA883695E0A@richrelevance.com> <4B95F222.6040504@2ndquadrant.com> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline In-reply-to: X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/94 X-Sequence-Number: 37919 Do keep the postgres xlog on a seperate ext2 partition for best performance. Other than that, xfs is definitely a good performer. Mike Stone