Re: vacuum, performance, and MVCC - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: vacuum, performance, and MVCC
Date
Msg-id 20060623033744.GI16383@surnet.cl
Whole thread Raw
In response to Re: vacuum, performance, and MVCC  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: vacuum, performance, and MVCC  ("Jonah H. Harris" <jonah.harris@gmail.com>)
List 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 by date:

Previous
From: Gavin Sherry
Date:
Subject: Re: vacuum, performance, and MVCC
Next
From: Christopher Kings-Lynne
Date:
Subject: Full Disjunction