X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7BE3D329E65 for ; Thu, 21 Oct 2004 09:38:52 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25984-08 for ; Thu, 21 Oct 2004 08:38:41 +0000 (GMT) Received: from bayswater1.ymogen.net (host-154-240-27-217.pobox.net.uk [217.27.240.154]) by svr1.postgresql.org (Postfix) with ESMTP id 9B53F32A0F7 for ; Thu, 21 Oct 2004 09:38:41 +0100 (BST) Received: from solent (unknown [213.165.136.10]) by bayswater1.ymogen.net (Postfix) with ESMTP id 029CBA37B2; Thu, 21 Oct 2004 09:38:41 +0100 (BST) Reply-To: From: "Matt Clark" To: "'Leeuw van der, Tim'" , Subject: Re: Anything to be gained from a 'Postgres Filesystem'? Date: Thu, 21 Oct 2004 09:38:40 +0100 Organization: Ymogen Ltd Message-ID: <008b01c4b749$5e0862c0$8300a8c0@solent> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/344 X-Sequence-Number: 8820 > Looking at that list, I got the feeling that you'd want to > push that PG-awareness down into the block-io layer as well, > then, so as to be able to optimise for (perhaps) conflicting > goals depending on what the app does; for the IO system to be > able to read the apps mind it needs to have some knowledge of > what the app is / needs / wants and I get the impression that > this awareness needs to go deeper than the FS only. That's a fair point, it would need be a kernel patch really, although not necessarily a very big one, more a case of looking at FDs and if they're flagged in some way then get the PGfs to do the job instead of/as well as the normal code path.