Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\))
Subject: Re: New server setup
From: =?iso-8859-1?Q?Niels_Kristian_Schj=F8dt?= <nielskristian@autouncle.com>
In-Reply-To: <1362501244.18199.YahooMailNeo@web162905.mail.bf1.yahoo.com>
Date: Tue, 5 Mar 2013 18:11:48 +0100
Cc: Craig James <cjames@emolecules.com>,
	"pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <2565FD8E-B7AD-4FCD-AB59-F16401FBD140@autouncle.com>
References: <4D6D1410-2208-4DAA-BD64-69BE1FD94E55@autouncle.com>
	<CAFwQ8rcA7xuPLXLXxKnz6AGfTit0iwFByM9ypfe-GfQmH0rvDA@mail.gmail.com>
	<06578781-EDBB-4BA9-B926-60491EBA5907@autouncle.com>
	<1362501244.18199.YahooMailNeo@web162905.mail.bf1.yahoo.com>
To: Kevin Grittner <kgrittn@ymail.com>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Thanks, that was actually what I just ended up doing yesterday. Any suggest=
ion how to tune pgbouncer?

BTW, I have just bumped into an issue that caused me to disable pgbouncer a=
gain actually. My web application is querying the database with a per reque=
st based SEARCH_PATH. This is because I use schemas to provide country base=
d separation of my data (e.g. english, german, danish data in different sch=
emas). I have pgbouncer setup to have a transactional behavior (pool_mode =
=3D transaction) - however some of my colleagues complained that it sometim=
es didn't return data from the right schema set in the SEARCH_PATH - you wo=
uldn't by chance have any idea what is going wrong wouldn't you?

#################### pgbouncer.ini
[databases]
production =3D

[pgbouncer]

logfile =3D /var/log/pgbouncer/pgbouncer.log
pidfile =3D /var/run/pgbouncer/pgbouncer.pid
listen_addr =3D localhost
listen_port =3D 6432
unix_socket_dir =3D /var/run/postgresql
auth_type =3D md5
auth_file =3D /etc/pgbouncer/userlist.txt
admin_users =3D postgres
pool_mode =3D transaction
server_reset_query =3D DISCARD ALL
max_client_conn =3D 500
default_pool_size =3D 20
reserve_pool_size =3D 5
reserve_pool_timeout =3D 10
#####################


Den 05/03/2013 kl. 17.34 skrev Kevin Grittner <kgrittn@ymail.com>:

> Niels Kristian Schj=F8dt <nielskristian@autouncle.com> wrote:
>=20
>> So my question is, should I also get something like pgpool2 setup
>> at the same time? Is it, from your experience, likely to increase
>> my throughput a lot more, if I had a connection pool of eg. 20
>> connections, instead of 300 concurrent ones directly?
>=20
> In my experience, it can make a big difference.  If you are just
> using the pooler for this reason, and don't need any of the other
> features of pgpool, I suggest pgbouncer.  It is a simpler, more
> lightweight tool.
>=20
> --=20
> Kevin Grittner
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company


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