Alvaro Herrera <alvherre@alvh.no-ip.org> 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