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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server: Add: > > * Allow buffered WAL writes
Date: 2004-08-14 04:03:54
Message-ID: 1255.1092456234@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Marc G. Fournier 2004-08-14 04:05:56 Re: pgsql-server: Add: > > * Allow buffered WAL writes
Previous Message Bruce Momjian 2004-08-14 03:52:05 Re: pgsql-server: Add: > > * Allow buffered WAL writes