Re: Two-phase commit - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Two-phase commit
Date
Msg-id 18565.1119111202@sss.pgh.pa.us
Whole thread Raw
In response to Re: Two-phase commit  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Two-phase commit
List pgsql-hackers
While cleaning out old mail about two-phase commit, I noticed this
thought from Oliver:

Oliver Jowett <oliver@opencloud.com> writes:
>>> Probably the next question is, do we want a database-side timeout on 
>>> how long prepared txns can stay alive before being summarily rolled back?
>> 
>> That sounds very dangerous to me. You could end up breaking global 
>> atomicity if some other resource in the global transaction committed.

> Right. You wouldn't enable it lightly..

> If pg_prepared_xacts had a time-of-preparation column, it would be 
> possible to put the timeout policy in an external client. Perhaps that's 
> a better solution?

This seems like a good idea to me in any case --- barring objections,
I will add this to the data structures and view.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Juan Pablo Espino
Date:
Subject: Login/logout
Next
From: Michael Fuhr
Date:
Subject: Re: Login/logout