pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Wong <markw@osdl.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Neil Conway <neilc@samurai.com>
Cc: Guy Thornley <guy@esphion.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: O_DIRECT setting
Date: Wed, 29 Sep 2004 18:45:10 -0700
Message-ID: <20040929184510.B15723@osdl.org> (raw)
In-Reply-To: <26123.1095951461@sss.pgh.pa.us>
References: <200409231335.i8NDZjR21993@candle.pha.pa.us>
	<26123.1095951461@sss.pgh.pa.us>

On Thu, Sep 23, 2004 at 10:57:41AM -0400, Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > TODO has:
> > 	* Consider use of open/fcntl(O_DIRECT) to minimize OS caching
> > Should the item be removed?
> 
> I think it's fine ;-) ... it says "consider it", not "do it".  The point
> is that we could do with more research in this area, even if O_DIRECT
> per se is not useful.  Maybe you could generalize the entry to
> "investigate ways of fine-tuning OS caching behavior".
> 
> 			regards, tom lane
> 

I talked to Jan a little about this during OSCon since Linux filesystems
(ext2, ext3, etc) let you use O_DIRECT.  He felt the only place where
PostgreSQL may benefit from this now, without managing its own buffer first,
would be with the log writer.  I'm probably going to get this wrong, but
he thought it would be interesting to try an experiment by taking X number
of pages to be flushed, sort them (by age? where they go on disk?) and
write them out.  He thought this would be a relatively easy thing to try,
a day or two of work.  We'd really love to experiment with it.

Mark



view thread (9+ messages)  latest in thread

Message-ID: <20040929184510.B15723@osdl.org>
Permalink:  ../20040929184510.B15723@osdl.org/
Also on:    postgresql.org/message-id/20040929184510.B15723@osdl.org

 · 

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: markw@osdl.org, tgl@sss.pgh.pa.us, pgman@candle.pha.pa.us, neilc@samurai.com, guy@esphion.com
  Subject: Re: O_DIRECT setting
  In-Reply-To: <20040929184510.B15723@osdl.org>

* 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