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

Tom Lane wrote:
> momjian(at)svr1(dot)postgresql(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073