pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Pierre-Frédéric Caillaud <lists@boutiquenumerique.com>
To: pgsql-performance@postgresql.org
Subject: Re: Reiser4
Date: Fri, 13 Aug 2004 11:01:52 -0700
Message-ID: <200408131101.52788.josh@agliodbs.com> (raw)
In-Reply-To: <opscohy8dvcq72hf@musicbox>
References: <s11c9b74.028@cbc.ca>
	<411CDC24.4090706@archonet.com>
	<opscohy8dvcq72hf@musicbox>

Pierre,

> 	Are there any plans in a future Postgresql version to support a special  
> fsync method for Reiser4 which will use the filesystem's transaction  
> engine, instead of an old kludge like fsync(), with a possibility of  
> vastly enhanced performance ?

I don't know of any such in progress right now.  Why don't you start it?  It 
would have to be an add-in since we support 28 operating systems and Reiser 
is AFAIK Linux-only, but it sounds like an interesting experiment.

> 	Is there also a possibility to tell Postgres : "I don't care if I lose 30  
> seconds of transactions on this table if the power goes out, I just want  
> to be sure it's still ACID et al. compliant but you can fsync less often  
> and thus be faster" (with a possibility of setting that on a per-table  
> basis) ?

Not per-table, no, but otherwise take a look at the Background Writer feature 
of 8.0.

-- 
-Josh Berkus
 "A developer of Very Little Brain"
 Aglio Database Solutions
 San Francisco




view thread (5+ messages)  latest in thread

Message-ID: <200408131101.52788.josh@agliodbs.com>
Permalink:  ../200408131101.52788.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200408131101.52788.josh@agliodbs.com

 · 

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: josh@agliodbs.com, lists@boutiquenumerique.com
  Subject: Re: Reiser4
  In-Reply-To: <200408131101.52788.josh@agliodbs.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