Re: how critical is WAL

> Hi,
>
> I happenned to come across the following in the
> documentation on WAL implementation in v7.1 -
>
> *****************************************************
> Before WAL, any crash during writing could result in:
>
>     1.index tuples pointing to non-existent table rows
>
>     2.index tuples lost in split operations
>
>     3.totally corrupted table or index page content,
> because of partially written data pages
> *****************************************************

Indexes could get corrupt, requiring rebuilding.  That problem is gone
with WAL.  Transaction commits where always safe.


--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026