Re: Anything to be gained from a 'Postgres Filesystem'? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Anything to be gained from a 'Postgres Filesystem'?
Date
Msg-id 28208.1099596848@sss.pgh.pa.us
Whole thread Raw
In response to Re: Anything to be gained from a 'Postgres Filesystem'?  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Anything to be gained from a 'Postgres Filesystem'?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
Simon Riggs <simon@2ndquadrant.com> 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

pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Next
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Restricting Postgres