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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026