Re: AW: AW: Re: Backup and Recovery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: AW: AW: Re: Backup and Recovery
Дата
Msg-id 9920.994429248@sss.pgh.pa.us
обсуждение исходный текст
Ответ на AW: AW: Re: Backup and Recovery  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Список pgsql-hackers
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
>> Wouldn't it be the same as the case where we *do* have UNDO?  How is a
>> removed tuple different from a tuple that was never there?

> HiHi, the problem is a subtile one. What if a previously aborted txn 
> produced a btree page split, that would otherwise not have happened ?

Good point.  We'd have to recognize btree splits (and possibly some
other operations) as things that must be done anyway, even if their
originating transaction is aborted.

There already is a mechanism for doing that: xlog entries can be written
without any transaction identifier (see XLOG_NO_TRAN).  Seems to me that
btree split XLOG records should be getting written that way now --- Vadim,
don't you agree?
        regards, tom lane


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Database Users Management and Privileges
Следующее
От: Gunnar Rønning
Дата:
Сообщение: Re: Database Users Management and Privileges