Re: Anything to be gained from a 'Postgres Filesystem'?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Date: 2004-11-04 19:34:08
Message-ID: 28208.1099596848@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Martin Foster 2004-11-04 20:30:19 Re: Restricting Postgres
Previous Message Steinar H. Gunderson 2004-11-04 19:20:04 Re: Anything to be gained from a 'Postgres Filesystem'?