RE: Is VACUUM still crash-safe?

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Is VACUUM still crash-safe?
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A234D31F4@sectorbase1.sectorbase.com
обсуждение исходный текст
Ответ на Is VACUUM still crash-safe?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > Ops, sorry - this case is not relevant to 7.1: WAL guarantees that
> > both pages will be updated on restart. Seems we are safe now.
> 
> First,already committed state isn't a normal state at least 
> without WAL. We must have access to db as less as possible in the
> state without WAL.
> AFAIK there has been no proof that we are sufficently safe in the 
> state under WAL. Don't you have to prove it if you dare to do another
> vacuum in the state ?
> 
> Second,isn't the following an example that VACUUM isn't crash-safe.
> 
>  VACUUM of a toast table crashed immediately after the movement
>  of a tuple(and before inserting corresponding index tuples).
>  Unfortunately the movement of a tuple is directly committed in
>  already committed state but corresponding index tuples aren't
>  inserted.

Now you've won -:)

Vadim


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Is VACUUM still crash-safe?
Следующее
От: Alfred Perlstein
Дата:
Сообщение: Re: (one more time) Patches with vacuum fixes available.