Re: MARKED_FOR_UPDATE && XMAX_COMMITTED == XMAX_INVALID ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: MARKED_FOR_UPDATE && XMAX_COMMITTED == XMAX_INVALID ?
Date: 2003-06-11 13:05:33
Message-ID: 10256.1055336733@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Manfred Koizar <mkoi-pg(at)aon(dot)at> writes:
> If a transaction marks a tuple for update and later commits without
> actually having updated the tuple, do we still need the information
> that the tuple has once been reserved for an update or can we simply
> set the HEAP_XMAX_INVALID hint bit of the tuple?

AFAICS this is a reasonable thing to do.

Eventually we might also be able to remove the bits of logic that check
for MARKED_FOR_UPDATE in a committed tuple, but that would not be
backwards-compatible so I'd vote against doing it immediately.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2003-06-11 14:26:11 Re: Okay, one mailing list problem still left...
Previous Message Tom Lane 2003-06-11 12:54:13 Okay, one mailing list problem still left...

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2003-06-11 14:24:36 Re: Adding Rendezvous support to postmaster
Previous Message Tom Lane 2003-06-11 12:55:39 Re: Adding Rendezvous support to postmaster