Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3A6DA650164 for ; Tue, 5 Aug 2008 01:54:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89887-02 for ; Tue, 5 Aug 2008 01:54:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ik-out-1112.google.com (ik-out-1112.google.com [66.249.90.180]) by postgresql.org (Postfix) with ESMTP id 5AF6664FEF9 for ; Tue, 5 Aug 2008 01:54:38 -0300 (ADT) Received: by ik-out-1112.google.com with SMTP id c30so4799080ika.3 for ; Mon, 04 Aug 2008 21:54:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:mime-version:content-type:content-transfer-encoding :content-disposition; bh=RirPI7hX7V4YrAtwam8nKpTx4yoxej6BzmlhWCkWK1o=; b=KpBSUCAVWV6YFGsKw2e7eWxqEkRyTLjCf5yrPMuLDF+fxe9OXMjoZigZg1luF3wRhA b1AaiHhTbuC19LSPwYj4Ya0KtaCihgLnsGvi+xnnmZR9BIKzUXihgwl/sy5D6DWnMjdl fhe02EmgQaqXoNhq1hdJ//7Gq57hfHiPHzM78= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:mime-version:content-type :content-transfer-encoding:content-disposition; b=LHbsyiZR68bh8OX7nrWH+xb5ko/4rWH9zlPINiuLJ7IiZbqnyTvW5EHRdktuLCzHnu lCKKxDhAzmdgmjVo+RvLWTWhjNwYa2CuwnYYDiWgzOFtqqVE+jjBUJ6FF6iwR0e+echu jj0AP71dHxnqPIoWzadYehrEJbgIpJQxgWBRE= Received: by 10.210.56.7 with SMTP id e7mr615236eba.1.1217912076902; Mon, 04 Aug 2008 21:54:36 -0700 (PDT) Received: by 10.210.72.10 with HTTP; Mon, 4 Aug 2008 21:54:36 -0700 (PDT) Message-ID: <70c01d1d0808042154u7b78d988vac1e461a93b0ba10@mail.gmail.com> Date: Mon, 4 Aug 2008 21:54:36 -0700 From: "Mark Wong" To: pgsql-performance@postgresql.org Subject: file system and raid performance Cc: "Gabrielle Roth" MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/7 X-Sequence-Number: 30888 Hi all, We've thrown together some results from simple i/o tests on Linux comparing various file systems, hardware and software raid with a little bit of volume management: http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide What I'd like to ask of the folks on the list is how relevant is this information in helping make decisions such as "What file system should I use?" "What performance can I expect from this RAID configuration?" I know these kind of tests won't help answer questions like "Which file system is most reliable?" but we would like to be as helpful as we can. Any suggestions/comments/criticisms for what would be more relevant or interesting also appreciated. We've started with Linux but we'd also like to hit some other OS's. I'm assuming FreeBSD would be the other popular choice for the DL-380 that we're using. I hope this is helpful. Regards, Mark