Re: AW: AW: Vacuum only with 20% old tuples

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: AW: AW: Vacuum only with 20% old tuples
Дата
Msg-id 10720.964621857@sss.pgh.pa.us
обсуждение исходный текст
Ответ на AW: AW: Vacuum only with 20% old tuples  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Список pgsql-hackers
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
>> We scan the log and come upon the rename.
>> Hmm, there's a file foo and no file bar ... looks like the 
>> rename didn't get done, so do it.  Ooops.

> No again. You come upon "starting rename operation" and then either 
>     no more log records (backend abort)
> or 
>     log record "rename succeeded"
> or
>     log record "rename failed"  --> transaction abort

> In this scenario you can decide what to do without second guessing.

If there are no more records, then you are reduced to guessing whether
you have to undo the rename or not.  If you guess wrong, you leave the
database in a corrupted state.
        regards, tom lane


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

Предыдущее
От: frank
Дата:
Сообщение: Re: [GENERAL] Is Pg 7.0.x's Locking Mechanism BROKEN?
Следующее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: AW: AW: Vacuum only with 20% old tuples