pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndquadrant.com>
To: Chris Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Date: Thu, 04 Nov 2004 19:03:47 +0000
Message-ID: <1099595027.4320.663.camel@localhost.localdomain> (raw)
In-Reply-To: <60bred39bg.fsf@dba2.int.libertyrms.com>
References: <BF88DF69D9E2884B9BE5160DB2B97A85010D6EB0@nlshl-exch1.eu.uis.unisys.com>
	<20041104120047.62810c8f@kingfisher.intern.logi-track.com>
	<opsgxwy5y1cq72hf@musicbox>
	<60bred39bg.fsf@dba2.int.libertyrms.com>

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




view thread (28+ messages)  latest in thread

Message-ID: <1099595027.4320.663.camel@localhost.localdomain>
Permalink:  ../1099595027.4320.663.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1099595027.4320.663.camel@localhost.localdomain

 · 

reply

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: simon@2ndquadrant.com, cbbrowne@acm.org
  Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
  In-Reply-To: <1099595027.4320.663.camel@localhost.localdomain>

* 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