Re: how critical is WAL

--- Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> > 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.
>

Thanks. I was specifically asking about Result '3'
above mentions 'totally corrupted table page content
because of partially written data pages' . Is this
also repairable ?

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/