pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Neil Conway <neilc@samurai.com>
To: Steinar H. Gunderson <sgunderson@bigfoot.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Date: Fri, 05 Nov 2004 15:28:39 +1100
Message-ID: <1099628919.10449.39.camel@localhost.localdomain> (raw)
In-Reply-To: <20041104192004.GA18793@uio.no>
References: <BF88DF69D9E2884B9BE5160DB2B97A85010D6EB0@nlshl-exch1.eu.uis.unisys.com>
	<20041104120047.62810c8f@kingfisher.intern.logi-track.com>
	<opsgxwy5y1cq72hf@musicbox>
	<60bred39bg.fsf@dba2.int.libertyrms.com>
	<20041104192004.GA18793@uio.no>

On Fri, 2004-11-05 at 06:20, Steinar H. Gunderson wrote:
> You mean, like, open(filename, O_DIRECT)? :-)

This disables readahead (at least on Linux), which is certainly not we
want: for the very case where we don't want to keep the data in cache
for a while (sequential scans, VACUUM), we also want aggressive
readahead.

-Neil





view thread (28+ messages)  latest in thread

Message-ID: <1099628919.10449.39.camel@localhost.localdomain>
Permalink:  ../1099628919.10449.39.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1099628919.10449.39.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: neilc@samurai.com, sgunderson@bigfoot.com
  Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
  In-Reply-To: <1099628919.10449.39.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