Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 42FD263289A for ; Mon, 23 Aug 2010 16:56:06 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 93795-09 for ; Mon, 23 Aug 2010 19:55:58 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from bay0-omc1-s2.bay0.hotmail.com (bay0-omc1-s2.bay0.hotmail.com [65.54.190.13]) by mail.postgresql.org (Postfix) with ESMTP id 0E2B6632B10 for ; Mon, 23 Aug 2010 16:55:57 -0300 (ADT) Received: from BAY149-W21 ([65.54.190.61]) by bay0-omc1-s2.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Mon, 23 Aug 2010 12:55:56 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_55f29cef-9165-43cc-a58c-5d255cf9546a_" X-Originating-IP: [94.8.170.116] From: Kieren Scott To: Subject: Re: pgBouncer for connection pooling Date: Mon, 23 Aug 2010 19:55:55 +0000 Importance: Normal In-Reply-To: <1282579351.665.4.camel@jd-desktop.unknown.charter.com> References: , <1282579351.665.4.camel@jd-desktop.unknown.charter.com> MIME-Version: 1.0 X-OriginalArrivalTime: 23 Aug 2010 19:55:56.0198 (UTC) FILETIME=[331E6460:01CB42FD] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/152 X-Sequence-Number: 35401 --_55f29cef-9165-43cc-a58c-5d255cf9546a_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Many thanks. > Subject: Re: [ADMIN] pgBouncer for connection pooling > From: jd@commandprompt.com > To: kierenscott@hotmail.com > CC: pgsql-admin@postgresql.org > Date: Mon=2C 23 Aug 2010 09:02:31 -0700 >=20 > On Mon=2C 2010-08-23 at 14:38 +0000=2C Kieren Scott wrote: > > Hi=2C > >=20 > > I have a web-based application (drupal) which uses PHP to make > > connections to a back-end postgresql 8.3 server. The application and > > database are on separate servers=2C but as we can get 20+ concurrent > > connections on the database I've looked at pgBouncer to try and reduce > > the overhead of new connections on the database. I currently have > > pgBouncer running on the same server as my postgres database but I was > > wondering whether this is a recommended setup - are the performance > > benefits of using a connection pooler overshadowed by the overhead of > > running pgBouncer on the same server as the database? > >=20 > > How are other people using pgBouncer? E.g. on a separate server from > > the database etc...? >=20 > We use it in both on separate boxes as well as local. As long as your > machine is handling the connection processing of the pooler fine=2C I > wouldn't worry about it. There are some specific high end off machine > things you can do (point at different databases on different machines > from a single pooler) that is cool but for just a Drupal website it is > probably not required. >=20 > JD >=20 > --=20 > PostgreSQL.org Major Contributor > Command Prompt=2C Inc: http://www.commandprompt.com/ - 509.416.6579 > Consulting=2C Training=2C Support=2C Custom Development=2C Engineering > http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt >=20 >=20 > --=20 > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin = --_55f29cef-9165-43cc-a58c-5d255cf9546a_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Many thanks.

>=3B Subject: Re: [ADMIN] pgBouncer for connection po= oling
>=3B From: jd@commandprompt.com
>=3B To: kierenscott@hotmai= l.com
>=3B CC: pgsql-admin@postgresql.org
>=3B Date: Mon=2C 23 Au= g 2010 09:02:31 -0700
>=3B
>=3B On Mon=2C 2010-08-23 at 14:38 +0= 000=2C Kieren Scott wrote:
>=3B >=3B Hi=2C
>=3B >=3B
>= =3B >=3B I have a web-based application (drupal) which uses PHP to make>=3B >=3B connections to a back-end postgresql 8.3 server. The applic= ation and
>=3B >=3B database are on separate servers=2C but as we ca= n get 20+ concurrent
>=3B >=3B connections on the database I've look= ed at pgBouncer to try and reduce
>=3B >=3B the overhead of new conn= ections on the database. I currently have
>=3B >=3B pgBouncer runnin= g on the same server as my postgres database but I was
>=3B >=3B won= dering whether this is a recommended setup - are the performance
>=3B = >=3B benefits of using a connection pooler overshadowed by the overhead o= f
>=3B >=3B running pgBouncer on the same server as the database?>=3B >=3B
>=3B >=3B How are other people using pgBouncer? E.g.= on a separate server from
>=3B >=3B the database etc...?
>=3B =
>=3B We use it in both on separate boxes as well as local. As long as= your
>=3B machine is handling the connection processing of the pooler= fine=2C I
>=3B wouldn't worry about it. There are some specific high = end off machine
>=3B things you can do (point at different databases o= n different machines
>=3B from a single pooler) that is cool but for j= ust a Drupal website it is
>=3B probably not required.
>=3B
&= gt=3B JD
>=3B
>=3B --
>=3B PostgreSQL.org Major Contributo= r
>=3B Command Prompt=2C Inc: http://www.commandprompt.com/ - 509.416.= 6579
>=3B Consulting=2C Training=2C Support=2C Custom Development=2C E= ngineering
>=3B http://twitter.com/cmdpromptinc | http://identi.ca/com= mandprompt
>=3B
>=3B
>=3B --
>=3B Sent via pgsql-adm= in mailing list (pgsql-admin@postgresql.org)
>=3B To make changes to y= our subscription:
>=3B http://www.postgresql.org/mailpref/pgsql-admin<= br> = --_55f29cef-9165-43cc-a58c-5d255cf9546a_--