From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Date: Thu, 04 Nov 2004 21:05:36 -0500
Message-ID: <m3r7n9t5hr.fsf@knuth.knuth.cbbrowne.com> (raw)
References: <BF88DF69D9E2884B9BE5160DB2B97A85010D6EB0@nlshl-exch1.eu.uis.unisys.com>
<20041104120047.62810c8f@kingfisher.intern.logi-track.com>
<opsgxwy5y1cq72hf@musicbox>
<60bred39bg.fsf@dba2.int.libertyrms.com>
<1099595027.4320.663.camel@localhost.localdomain>
After a long battle with technology, simon@2ndquadrant.com (Simon Riggs), an earthling, wrote:
> 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.
We're not talking about the same cache.
ARC does these exact things for _shared memory_ cache, and is the
obvious inspiration.
But it does more or less nothing about the way OS file buffer cache is
managed, and the handling of _that_ would be the point of modifying OS
filesystem semantics.
--
select 'cbbrowne' || '@' || 'linuxfinances.info';
http://www3.sympatico.ca/cbbrowne/oses.html
Have you ever considered beating yourself with a cluestick?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
In-Reply-To: <m3r7n9t5hr.fsf@knuth.knuth.cbbrowne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox