Re: XID wraparound and busy databases

On Wednesday 15 August 2007 13:54, Tom Lane wrote:
> Decibel! <decibel@decibel.org> writes:
> > Aren't there potential issues with keeping the same XID if a transaction
> > in the middle has modified data?
>
> I don't see any, as long as you take a new snapshot.
>

I'm a little confused, wouldnt the transaction that waits 30 minutes before 
modifying data need to get an XID that jives with the system when it's 
transaction started, not when it began manipulating data?   Would it really 
be safe to take a new snapshot at that time, istm concurrent writers might 
have caused potential issues by that point. 

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL