Re: how critical is WAL

--- Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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/