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

From Bruce Momjian
Subject Re: pgsql-server: Add: > > * Allow buffered WAL writes
Date
Msg-id 200408140323.i7E3Nef23930@candle.pha.pa.us
Whole thread Raw
In response to Re: pgsql-server: Add: > > * Allow buffered WAL writes and fsync > >  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql-server: Add: > > * Allow buffered WAL writes
List pgsql-committers
Tom Lane wrote:
> momjian@svr1.postgresql.org (Bruce Momjian) writes:
> > Add:
> >> * Allow buffered WAL writes and fsync
> >>
> >> Instead of guaranteeing recovery of all committed transactions, this
> >> would provide improved performance by delaying WAL writes and fsync
> >> so an abrupt operating system restart might lose a few seconds of
> >> committed transactions but still be consistent.
>
> Who exactly signed onto this as a good idea?  It sure doesn't square
> with my ideas of an ACID database.  Committed means committed, not
> "maybe if you're lucky committed".

True but we support fsync.  Certainly it would be more useful than
fsync, and it might allow us to remove fsync.

No one has to sign TODO items, BTW.  They are added and removed as
requested.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql-server: Add: > > * Allow buffered WAL writes and fsync > >
Next
From: Tom Lane
Date:
Subject: Re: pgsql-server: Add: > > * Allow buffered WAL writes