Tom Lane <tgl@sss.pgh.pa.us> writes:
> > This could be useful if you want to have X pending database transactions
> > and Y max concurrent database connections, where X is significantly greater
> > than Y (magnitudes higher?).
>
> I don't think the prepared-xacts facility has the performance that would
> be needed to sustain that kind of usage. Suspend/resume would not be
> all that cheap, and a suspended transaction would still hold a lot of
> resources (locks mostly).
Well it'll be better than having to maintain a connection for each
transaction.
--
greg