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 29577.1099601151@sss.pgh.pa.us
Whole thread Raw
In response to 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 19:34, Tom Lane wrote:
>> 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.

> I guess a difference in viewpoints. I'm inclined to give most of the RAM
> to PostgreSQL, since as you point out, the kernel is out of our control.
> That way, we can do what we like with it - keep it or not, as we choose.

That's always been a Bad Idea for three or four different reasons, of
which ARC will eliminate no more than one.

            regards, tom lane

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: Restricting Postgres