Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> writes: > I wonder if we could have a way to "suspend" a transaction and restart > it later in another backend. I think we could do something like this > using the 2PC machinery. > Not that I'm up for coding it; just an idea that crossed my mind. It's not impossible, perhaps, but it would require an order-of-magnitude expansion of the 2PC machinery --- the amount of state associated with an open execution plan is daunting. I think there are discussions about this in the archives. regards, tom lane
