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 EACCA32A03C for ; Thu, 21 Oct 2004 09:32:50 +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 27321-03 for ; Thu, 21 Oct 2004 08:32:45 +0000 (GMT) Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10]) by svr1.postgresql.org (Postfix) with ESMTP id 0497732A026 for ; Thu, 21 Oct 2004 09:32:46 +0100 (BST) Received: (qmail 6706 invoked from network); 21 Oct 2004 10:32:47 +0200 Received: from unknown (HELO musicbox) (boutiquenumerique-lists@192.168.0.2) by boutiquenumerique.com with SMTP; 21 Oct 2004 10:32:47 +0200 To: matt@ymogen.net, pgsql-performance@postgresql.org Subject: Re: Anything to be gained from a 'Postgres Filesystem'? References: <008601c4b743$aff57f10$8300a8c0@solent> Message-ID: From: =?iso-8859-15?Q?Pierre-Fr=E9d=E9ric_Caillaud?= Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?= Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Date: Thu, 21 Oct 2004 10:33:31 +0200 In-Reply-To: <008601c4b743$aff57f10$8300a8c0@solent> User-Agent: Opera M2/7.54 (Linux, build 751) 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/343 X-Sequence-Number: 8819 Reiser4 ? On Thu, 21 Oct 2004 08:58:01 +0100, Matt Clark wrote: > I suppose I'm just idly wondering really. Clearly it's against PG > philosophy to build an FS or direct IO management into PG, but now it's > so > relatively easy to plug filesystems into the main open-source Oses, It > struck me that there might be some useful changes to, say, XFS or ext3, > that > could be made that would help PG out. > > I'm thinking along the lines of an FS that's aware of PG's strategies and > requirements and therefore optimised to make those activities as > efiicient > as possible - possibly even being aware of PG's disk layout and treating > files differently on that basis. > > Not being an FS guru I'm not really clear on whether this would help much > (enough to be worth it anyway) or not - any thoughts? And if there were > useful gains to be had, would it need a whole new FS or could an existing > one be modified? > > So there might be (as I said, I'm not an FS guru...): > * great append performance for the WAL? > * optimised scattered writes for checkpointing? > * Knowledge that FSYNC is being used for preserving ordering a lot of the > time, rather than requiring actual writes to disk (so long as the writes > eventually happen in order...)? > > > Matt > > > > Matt Clark > Ymogen Ltd > P: 0845 130 4531 > W: https://ymogen.net/ > M: 0774 870 1584 > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >