> With stock PostgreSQL... how many committed transactions can one lose
> on a simple system crash/reboot? With Oracle or Informix, the answer
> is zero. Is that true with PostgreSQL in fsync mode? If not, does it

It's true or better say should be, keeping in mind probability of bugs.

> lose all in the log, or just those not yet written to the DB?

BAR is not for "simple crash" but for the disk crashes. In this case
one will lose as much as WAL files lost.

Vadim

Tue, 3 Jul 2001 12:55:47 -0700 
"Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
RE: Re: Backup and Recovery