Re: how critical is WAL

Поиск
Список
Период
Сортировка
От Rini Dutta
Тема Re: how critical is WAL
Дата
Msg-id 20010222204850.25403.qmail@web2902.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: how critical is WAL  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: how critical is WAL
Список 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 по дате отправления:

Предыдущее
От: "Brent R. Matzelle"
Дата:
Сообщение: Re: PostgreSQL 7.1 Linux Installation
Следующее
От: Bruce Momjian
Дата:
Сообщение: Upcoming PostgreSQL events