Frank Zhou <zhouxuesong@gmail.com> 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