X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 03D00D1C951; Wed, 7 Apr 2004 13:37:44 -0300 (ADT) 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 85699-09; Wed, 7 Apr 2004 13:37:42 -0300 (ADT) Received: from gp.word-to-the-wise.com (gp.word-to-the-wise.com [64.71.176.18]) by svr1.postgresql.org (Postfix) with ESMTP id 73E78D1BA90; Wed, 7 Apr 2004 13:37:41 -0300 (ADT) Received: by gp.word-to-the-wise.com (Postfix, from userid 500) id 14FC1900060; Wed, 7 Apr 2004 09:29:47 -0700 (PDT) Date: Wed, 7 Apr 2004 09:29:47 -0700 From: Steve Atkins To: pgsql-admin@postgresql.org Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Raw devices vs. Filesystems Message-ID: <20040407162946.GA7271@gp.word-to-the-wise.com> References: <71E37EF6B7DCC1499CEA0316A25683280105786A@loki.wc.globexplorer.net> <5719.1081315562@sss.pgh.pa.us> <20040407071858.GA7973@elbereth.noviforum.si> <200404070909.16123.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200404070909.16123.josh@agliodbs.com> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/111 X-Sequence-Number: 13084 On Wed, Apr 07, 2004 at 09:09:16AM -0700, Josh Berkus wrote: > If your intention in this test is to show the superiority of raw devices, let > me give you a reality check: barring some major corporate backing getting > involved, we can't possibly implement our own PG-FS for database support. We > already have a TODO list which is far too long for our developer pool, and > implementing a custom FS either takes a large team (OCFS) or several years of > development (Reiser). Is there any documentation as to what guarantees PostgreSQL requires from the filesystem, or what posix semantics can be relaxed? Cheers, Steve