Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U5dlc-0003pM-NZ for pgsql-performance@arkaria.postgresql.org; Wed, 13 Feb 2013 14:57:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1U5dlc-0001Db-84 for pgsql-performance@arkaria.postgresql.org; Wed, 13 Feb 2013 14:57:00 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U5dlb-0001DW-EE for pgsql-performance@postgresql.org; Wed, 13 Feb 2013 14:56:59 +0000 Received: from nm26.bullet.mail.bf1.yahoo.com ([98.139.212.185]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1U5dlY-0004pF-Bu for pgsql-performance@postgresql.org; Wed, 13 Feb 2013 14:56:59 +0000 Received: from [98.139.212.146] by nm26.bullet.mail.bf1.yahoo.com with NNFMP; 13 Feb 2013 14:56:54 -0000 Received: from [98.139.212.239] by tm3.bullet.mail.bf1.yahoo.com with NNFMP; 13 Feb 2013 14:56:54 -0000 Received: from [127.0.0.1] by omp1048.mail.bf1.yahoo.com with NNFMP; 13 Feb 2013 14:56:54 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 289051.85026.bm@omp1048.mail.bf1.yahoo.com Received: (qmail 15685 invoked by uid 60001); 13 Feb 2013 14:56:54 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1360767414; bh=AIMH3eaRL/al9QqGNIH4kY2Y42d+FvTWm6WDbG3ML/g=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=2miVICLDdXI3/7dWNmxiw5Ip5xLUMR8lO1fFuawLOUS3PVM4KuFFFDdJUqG459gSiSDQ3/xXOOIT3/LDQ+AasxlaM/JaRJNNSGzBy5sgVlF7JXh2ZSyYfC8Z/pDvZtVN8gR9CVXjRPgTh44uIWFSqS2b1zYCQUVK6MEeZlarbSQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=4dJ0LSW1htHOiND5kfCna05NxwJ9moA3DuUQmd0R3o/tqo4MJF38PZ1r6WnWVcPES6Osq4jdS3/U6X9+gyyov0ih09inuxZleeeC2TUiUlx/+Bs9XKQgNM3PY1LNBBSU0pZLRsWAE3lkbjMM9F9hjXqFU/7UA0MuM5hUffJMPhA=; X-YMail-OSG: mOyh_SUVM1kt0wK2o5VOhWA8gp8vUUCM5blLeHTFBYE2jCb usS9VRHVMuvFa2JQitHDCIV1DW5eLIoF6RjP2uZsIBYCUOD.9VHJbPk.V7q0 QRNKPPNSazM1qMhG4peYsO7CRob_mc8NVJCPSYFkHRKqnh8d9ceUs9nWwFMy 6QNdqMB6kIwiNGPv4pOt6ZA7TdOAMWfSYPMm3pIkT3npti5Sd0hYxXOZaVV8 PWVmXIyeWrgVAVUlyYY6.eqznKMWlJ4Tqfjk2U.KoFos8uGPFHMoiGT5C3CB B.gtXS6nGe2Q4pfnMyG_N1dglW.V2X2e8iYKqWboHTQpI2wPM2ggUU4T.QJS tPPz6l.hj6TGOGn7q_sSqNuemPynYRn7goTFPxagOkFsrnii2izjWaCS_5dG uKSMdrf2LiVKEhMtuIQda1k23V.DBlA4JYnUsWNmhEIE_BwH2P2GUWoEZ4fG lCSf_I_qNpl8QkEte.GBHvk4YZi6Awp9dWhw9.FYVTuYLzDbFuQRhfRasr3o a2mU2iS.oihtvOPRMAw2Wls27YPmBnggLwPy_SNc3AGy05NjtxjFril5Q4Sy wnLWWirdhy9jIuqKJUBM5VBRlOLoXXjMRjp_89CWeosYR_BN2DTETb6Btyk8 LBrUQwu56jglND4aj07zPLwE- Received: from [76.255.18.237] by web162901.mail.bf1.yahoo.com via HTTP; Wed, 13 Feb 2013 06:56:54 PST X-Rocket-MIMEInfo: 001.001, WWV0a2luIMOWenTDvHJrIDx5ZXRraW44NUBnbWFpbC5jb20.IHdyb3RlOgoKPiBXaGljaCBrZXkgc2hvdWxkIGkgc2V0IGZvciBjaGFuZ2luZyB0aGUgbGltaXQgb2YgY29ubmVjdGlvbgo.IGJldHdlZW4gcGdib3VuY2VyIDwtPiBwb3NncmVzOC40PwoKVGhlIG9wdGlvbnMgd2hpY2ggZW5kIGluIF9wb29sX3NpemUuwqAgbWF4X2NsaWVudF9jb25uIHNwZWNpZmllcyBob3cKbWFueSBhcHBsaWNhdGlvbiBjb25uZWN0aW9ucyBjYW4gYmUgbWFkZSB0byBwZ2JvdW5jZXIuCgpJdCdzIGdlbmVyYWxseSBiZXN0IHQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.133.508 References: Message-ID: <1360767414.10062.YahooMailNeo@web162901.mail.bf1.yahoo.com> Date: Wed, 13 Feb 2013 06:56:54 -0800 (PST) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: connection poolers' db connections To: =?iso-8859-1?Q?Yetkin_=D6zt=FCrk?= , "pgsql-performance@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org Yetkin =D6zt=FCrk wrote: > Which key should i set for changing the limit of connection > between pgbouncer <-> posgres8.4? The options which end in _pool_size.=A0 max_client_conn specifies how many application connections can be made to pgbouncer. It's generally best to use pool_mode of transaction if you can. > I want to increase the connections of pgbouncer opened on posgres > (pgbouncer<->posgres) to eliminate waiting connections in the > pool, to consume queries faster. Be sure to read this: http://wiki.postgresql.org/wiki/Number_Of_Database_Connections Beyond a certain point, starting the query sooner will cause it to finish later.=A0 Really. --=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