References: <1402507690.19836.YahooMailNeo@web122306.mail.ne1.yahoo.com>
	<26995497.123.1402508346235.JavaMail.lenovo@lenovo-PC>
	<1402508911.42015.YahooMailNeo@web122301.mail.ne1.yahoo.com>
 <CABeXrnet8bnV=__XdpBvbD89eMRN+0EZfZaotyPOE2YaNXB4AQ@mail.gmail.com>
Message-ID: <1402626535.75204.YahooMailNeo@web122304.mail.ne1.yahoo.com>
Date: Thu, 12 Jun 2014 19:28:55 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: PostgreSQL db
To: Frank Zhou <zhouxuesong@gmail.com>
Cc: Amit Sharma <asharma@verts.co.in>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <CABeXrnet8bnV=__XdpBvbD89eMRN+0EZfZaotyPOE2YaNXB4AQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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.=A0 If you can configure it for transaction mode and use a
very small number of pools it can be very effective.=A0 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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin