Re: Dead Space Map - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Dead Space Map
Date
Msg-id 87hd6jwajr.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Dead Space Map  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:

> Greg Stark wrote:
> > 
> > If you commit each update then your tuple might well be visible to other
> > transactions, how would you check that?
> 
> You check the xmin/xmax using standard visibility rules.

Would that really find anything? Even putting aside your own transaction
wouldn't it pick up any older transaction that started before yours and is
still running? They can't really see it but short of actually looking at their
snapshots I don't think you can determine that.

-- 
greg



pgsql-hackers by date:

Previous
From: John DeSoi
Date:
Subject: Re: character encoding in StartupMessage
Next
From: Tom Lane
Date:
Subject: Re: Zeroing damaged pages