[Bucardo-general] Connection Pooling

Greg Sabino Mullane greg at endpoint.com
Wed Oct 3 03:35:13 UTC 2012


> Which type of pooling should I use: transaction or statement?

Certainly not statement! And be careful with transaction as well. 
We do some transation-spanning things, esp. session_replication_role. 
I *think* it will all work out[1] due to when those are set and when 
the transaction boundaries appear, but I'd check that close before 
deciding on transaction-level pgbouncer.

[1] No time to check myself right now

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20121002/91f3d3c2/attachment.sig>


More information about the Bucardo-general mailing list