Re: VACUUM and open transactions - Mailing list pgsql-general

From Tom Lane
Subject Re: VACUUM and open transactions
Date
Msg-id 7130.1161303633@sss.pgh.pa.us
Whole thread Raw
In response to Re: VACUUM and open transactions  (Joseph S <jks@selectacast.net>)
List pgsql-general
Joseph S <jks@selectacast.net> writes:
> But if the tuple in question was created and then deleted after the
> transaction, the transaction should still not need to see it.

No, because it might have taken a snapshot during the interval where the
tuple was good.

            regards, tom lane

pgsql-general by date:

Previous
From: Ritesh Nadhani
Date:
Subject: Re: Some newbie question
Next
From: Jeff Davis
Date:
Subject: Re: Some newbie question