Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id A9AFA632FE2 for ; Tue, 24 Aug 2010 07:40:08 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 20449-06 for ; Tue, 24 Aug 2010 10:39:59 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from bay0-omc4-s28.bay0.hotmail.com (mail2.hotmail.com [65.54.190.230]) by mail.postgresql.org (Postfix) with ESMTP id 63E12632EB2 for ; Tue, 24 Aug 2010 07:40:00 -0300 (ADT) Received: from BAY149-W11 ([65.54.190.199]) by bay0-omc4-s28.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Tue, 24 Aug 2010 03:39:58 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_386017ce-98b3-4bf1-93a1-200d3922c5be_" X-Originating-IP: [91.206.0.43] From: Kieren Scott To: , Subject: Re: pgBouncer for connection pooling Date: Tue, 24 Aug 2010 10:39:58 +0000 Importance: Normal In-Reply-To: References: , MIME-Version: 1.0 X-OriginalArrivalTime: 24 Aug 2010 10:39:58.0463 (UTC) FILETIME=[B2C5B8F0:01CB4378] 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/171 X-Sequence-Number: 35420 --_386017ce-98b3-4bf1-93a1-200d3922c5be_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks Benjamin. Most of the time the database only has 5-6 connections=2C however we occasi= onally get a flood of connections which can mean 60+ connections (when a co= mpany email is sent out with a link to a web page)=2C so I'm looking to han= dle these spikes in connections as best I can :-) Kieren Subject: Re: [ADMIN] pgBouncer for connection pooling Date: Mon=2C 23 Aug 2010 22:15:34 -0600 From: kraj@servoyant.com To: kierenscott@hotmail.com=3B pgsql-admin@postgresql.org I have pgbouncer running on the same server=2C and I get over 2000 calls to a php page per minute. Each call does inserts data digests into partitioned tables. I also have a multi-threaded daemon connected to the same database running background operations on the data coming in. Works flawlessly. BTW=2C 20 connections is not a heavy load at all. In my application=2C pgbouncer has opened about 60 backends to handle the cases where I have a high oncurrency of data coming in at once= =2C but usually the # non-idle connections is < 10. =20 =20 From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] = On Behalf Of Kieren Scott Sent: Monday=2C August 23=2C 2010 8:38 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] pgBouncer for connection pooling =20 Hi=2C 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 separat= e 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 runni= ng pgBouncer on the same server as the database? How are other people using pgBouncer? E.g. on a separate server from the database etc...? Thanks in advance. = --_386017ce-98b3-4bf1-93a1-200d3922c5be_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Thanks Benjamin.
Most of the time the database only has 5-6 connections= =2C however we occasionally get a flood of connections which can mean 60+ c= onnections (when a company email is sent out with a link to a web page)=2C = so I'm looking to handle these spikes in connections as best I can :-)
<= br>Kieren

Subject: Re: [ADMIN] pgBouncer for= connection pooling
Date: Mon=2C 23 Aug 2010 22:15:34 -0600
From: kra= j@servoyant.com
To: kierenscott@hotmail.com=3B pgsql-admin@postgresql.or= g

I have pgbouncer = running on the same server=2C and I get over 2000 calls to a php page per minute.

Each call does in= serts data digests into partitioned tables.

I also have a mul= ti-threaded daemon connected to the same database running background operations on the data coming in.

Works flawlessly.=

BTW=2C 20 connect= ions is not a heavy load at all.

In my application= =2C pgbouncer has opened about 60 backends to handle the cases where I have a high oncurrency of data coming in at once= =2C but usually the # non-idle connections is <=3B 10.

 =3B

 =3B

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] = On Behalf Of Kieren Scott
Sent: Monday=2C August 23=2C 2010 8:38 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] pgBouncer for connection pooling

 =3B

Hi=2C

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 separat= e 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 runni= ng pgBouncer on the same server as the database?

How are other people using pgBouncer? E.g. on a separate server from the database etc...?

Thanks in advance.

= --_386017ce-98b3-4bf1-93a1-200d3922c5be_--