X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8A1DCD1B7E6 for ; Wed, 28 Jan 2004 18:37:30 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 33730-04 for ; Wed, 28 Jan 2004 14:37:00 -0400 (AST) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id EA7A5D1B449 for ; Wed, 28 Jan 2004 14:36:58 -0400 (AST) Received: from osdl.org (markw@ibm-b.pdx.osdl.net [172.20.1.51]) by mail.osdl.org (8.11.6/8.11.6) with ESMTP id i0SIaqo25693; Wed, 28 Jan 2004 10:36:54 -0800 Message-Id: <200401281836.i0SIaqo25693@mail.osdl.org> Date: Wed, 28 Jan 2004 10:36:39 -0800 (PST) From: markw@osdl.org Subject: Re: High Performance/High Reliability File system on To: dave@hub.org Cc: pgsql-performance@postgresql.org In-Reply-To: <001001c3e1d0$072b20e0$6601a8c0@thore> MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/295 X-Sequence-Number: 5469 On 23 Jan, Dave Thompson wrote: > Hello All > > Just wanted to gather opinions on what file system has the best balance between performance and reliability when used on a quad processor machine running SuSE64. Thanks > > DAve Hi Dave, I have some data for performance using our DBT-2 workload (OLTP type transactions) with Linux-2.6 with various filesystems and i/o schedulers. I know it doesn't address the reliability part of your question, and it's in a completely different environment (32-bit as well as a different distro), but if you think you'll find the results interesting: http://developer.osdl.org/markw/fs/project_results.html Mark