Re: pgsql-server: Add: > > * Allow buffered WAL writes - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql-server: Add: > > * Allow buffered WAL writes
Date
Msg-id 1255.1092456234@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql-server: Add: > > * Allow buffered WAL writes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: pgsql-server: Add: > > * Allow buffered WAL writes  ("Marc G. Fournier" <scrappy@postgresql.org>)
Re: pgsql-server: Add: > > * Allow buffered WAL writes  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-committers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Many databases offer this feature.  The submitter asked for it,

Actually he didn't --- AFAICS you misinterpreted the thread completely.
The original suggestion was that we might be able to exploit a
transactional filesystem to improve performance *without* sacrificing
any correctness guarantees.  Delayed fsync has nothing to do with that.

(I'm dubious whether there's any performance improvement to be had that
would be worth the code uglification involved, since we're surely not
going to *require* a transactional filesystem and so two very different
code paths seem to be needed.  But it's at least something to think about.)

Again, the fact that Oracle offers such a feature doesn't make it a good
idea.

            regards, tom lane

pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgsql-server: Add: > > * Allow buffered WAL writes
Next
From: "Marc G. Fournier"
Date:
Subject: Re: pgsql-server: Add: > > * Allow buffered WAL writes