pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Neil Conway <neilc@samurai.com>
To: Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Date: Fri, 05 Nov 2004 15:33:32 +1100
Message-ID: <1099629212.10449.45.camel@localhost.localdomain> (raw)
In-Reply-To: <opsgxwy5y1cq72hf@musicbox>
References: <BF88DF69D9E2884B9BE5160DB2B97A85010D6EB0@nlshl-exch1.eu.uis.unisys.com>
	<20041104120047.62810c8f@kingfisher.intern.logi-track.com>
	<opsgxwy5y1cq72hf@musicbox>

On Thu, 2004-11-04 at 23:29, Pierre-Frédéric Caillaud wrote:
> 	There is also the fact that syncing after every transaction could be  
> changed to syncing every N transactions (N fixed or depending on the data  
> size written by the transactions) which would be more efficient than the  
> current behaviour with a sleep.

Uh, which "sleep" are you referring to?

Also, how would interacting with the filesystem's journal effect how
often we need to force-write the WAL to disk? (ISTM we need to sync
_something_ to disk when a transaction commits in order to maintain the
WAL invariant.)

> 	There's fadvise to tell the OS to readahead on a seq scan (I think the OS  
> detects it anyway)

Not perfectly, though; also, Linux will do a more aggressive readahead
if you tell it to do so via posix_fadvise().

> if there was a system call telling the OS "in the  
> next seconds I'm going to read these chunks of data from this file (gives  
> a list of offsets and lengths), could you put them in your cache in the  
> most efficient order without seeking too much, so that when I read() them  
> in random order, they will be in the cache already ?".

http://www.opengroup.org/onlinepubs/009695399/functions/posix_fadvise.html

POSIX_FADV_WILLNEED 
        Specifies that the application expects to access the specified
        data in the near future.

-Neil





view thread (28+ messages)  latest in thread

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