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 C4A1D3A4943 for ; Thu, 4 Nov 2004 19:34:17 +0000 (GMT) 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 91741-05 for ; Thu, 4 Nov 2004 19:34:15 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id BCA563A4923 for ; Thu, 4 Nov 2004 19:34:15 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iA4JY8aK028209; Thu, 4 Nov 2004 14:34:08 -0500 (EST) To: Simon Riggs Cc: Chris Browne , pgsql-performance@postgresql.org Subject: Re: Anything to be gained from a 'Postgres Filesystem'? In-reply-to: <1099595027.4320.663.camel@localhost.localdomain> References: <20041104120047.62810c8f@kingfisher.intern.logi-track.com> <60bred39bg.fsf@dba2.int.libertyrms.com> <1099595027.4320.663.camel@localhost.localdomain> Comments: In-reply-to Simon Riggs message dated "Thu, 04 Nov 2004 19:03:47 +0000" Date: Thu, 04 Nov 2004 14:34:08 -0500 Message-ID: <28208.1099596848@sss.pgh.pa.us> From: Tom Lane 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: 200411/55 X-Sequence-Number: 9009 Simon Riggs writes: > On Thu, 2004-11-04 at 15:47, Chris Browne wrote: >> Something like a "read_uncached()" call... >> >> That would mean that a seq scan or a vacuum wouldn't force useful data >> out of cache. > ARC does almost exactly those two things in 8.0. But only for Postgres' own shared buffers. The kernel cache still gets trashed, because we have no way to suggest to the kernel that it not hang onto the data read in. regards, tom lane