Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans
Date
Msg-id 9585.1093473829@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> I don't know the details, but with postgres's model wouldn't it be a simply
> matter of treating every tuple found as having been inserting or deleted
> without checking to see if the transaction id in the tuple is committed?

No.  At least not if you want a view of the data that's even marginally
sane (not multiple versions of the same row, for instance, or versions
that are definitely dead by anyone's viewpoint).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: futex
Next
From: pgsql@mohawksoft.com
Date:
Subject: Re: Contrib -- PostgreSQL shared variables -with swap