Frank Zhou <zhouxuesong@xxxxxxxxx> wrote: > We are using client side pg_bouncer, do you think it is also an > acceptable option? It can be. If you can configure it for transaction mode and use a very small number of pools it can be very effective. Other modes don't help as much, although they can be easier to set up. If you are using Java I found Apache dbcp to be excellent. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
