Tom Lane <tgl@xxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
