Re: Unneccessary cmax in heap tuple ? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Unneccessary cmax in heap tuple ?
Date
Msg-id 29100.972497078@sss.pgh.pa.us
Whole thread Raw
In response to Re: Unneccessary cmax in heap tuple ?  (devik@cdi.cz)
List pgsql-hackers
devik@cdi.cz writes:
> Ahh I did not know that there is need to test tuple for
> validity for some past cid. I thought that we only need
> to know whether tuple has been updated by current cid
> to ensure that it will not be scanned again in the same
> cid... Where am I wrong ?

In situations like SQL function calls, it may be necessary to suspend
a table scan while we go off and do other commands, then come back and
resume the table scan.  So there can be multiple scans with different
command IDs in progress within a transaction.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: --with-perl=/path/to/prefered/perl?
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: failed runcheck