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

From Simon Riggs
Subject Re: Anything to be gained from a 'Postgres Filesystem'?
Date
Msg-id 1099595027.4320.663.camel@localhost.localdomain
Whole thread Raw
In response to Re: Anything to be gained from a 'Postgres Filesystem'?  (Chris Browne <cbbrowne@acm.org>)
Responses Re: Anything to be gained from a 'Postgres Filesystem'?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Thu, 2004-11-04 at 15:47, Chris Browne wrote:

> Another thing that would be valuable would be to have some way to say:
>
>   "Read this data; don't bother throwing other data out of the cache
>    to stuff this in."
>
> 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.

Seq scans do get put in cache, but in a way that means they don't spoil
the main bulk of the cache.

--
Best Regards, Simon Riggs


pgsql-performance by date:

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