Re: vacuum, performance, and MVCC

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: vacuum, performance, and MVCC
Дата
Msg-id 20060623033744.GI16383@surnet.cl
обсуждение исходный текст
Ответ на Re: vacuum, performance, and MVCC  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Ответы Re: vacuum, performance, and MVCC  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Список pgsql-hackers
Jonah H. Harris wrote:
> On 6/22/06, Gavin Sherry <swm@linuxworld.com.au> wrote:

> >When an update occurs, the existing row version is
> >copied to te UNDO file
> 
> Not in all systems.  A few now perform in-memory UNDO and only write
> it to disk if and when it is required.

How does that work?  If the last transaction is not finished after it
wrote the tuple when the power goes out, and the UNDO is not written to
disk either, how do you reconstruct the tuple at all?

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Gavin Sherry
Дата:
Сообщение: Re: vacuum, performance, and MVCC
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Full Disjunction