> 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