Re: how critical is WAL - Mailing list pgsql-general

From Rini Dutta
Subject Re: how critical is WAL
Date
Msg-id 20010222204850.25403.qmail@web2902.mail.yahoo.com
Whole thread Raw
In response to Re: how critical is WAL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: how critical is WAL  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
--- 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/

pgsql-general by date:

Previous
From: "Brent R. Matzelle"
Date:
Subject: Re: PostgreSQL 7.1 Linux Installation
Next
From: Bruce Momjian
Date:
Subject: Upcoming PostgreSQL events