Re: WAL logging of heap_mark4update - Mailing list pgsql-hackers

From Tom Lane
Subject Re: WAL logging of heap_mark4update
Date
Msg-id 12138.1105825736@sss.pgh.pa.us
Whole thread Raw
In response to WAL logging of heap_mark4update  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: WAL logging of heap_mark4update
List pgsql-hackers
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> Hackers,
> In access/heap/heapam.c, in heap_mark4update(), there's a comment that
> states

>     /*
>      * XLOG stuff: no logging is required as long as we have no
>      * savepoints. For savepoints private log could be used...
>      */

> Is this still true in light of 8.0's savepoints?

It isn't.  Since mark4update is simply establishing a lock, which isn't
going to be held across a system crash anyway, I see no need to WAL-log
it.  (But hmmm ... to support 2PC we'd probably need to do so ...)

> I think the comment was made assuming that savepoints would be
> implemented using REDO,

I think the same.

> In any case I'm contemplating changing exclusive row locks to use
> LockAcquire, and supporting shared row locks using the same mechanism.
> All this per previous discussion on -hackers.  We could get rid of
> heap_mark4update if that's done, right?

Right.  The 2PC connection is another reason to do it that way --- 2PC
would require some way to save locks anyhow, and it'd be nice if there
were only one mechanism to deal with not two.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: FATAL: catalog is missing 1 attribute(s) for relid
Next
From: Bruce Momjian
Date:
Subject: Encodings and docs