Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCuoh-000509-Pp for pgsql-performance@arkaria.postgresql.org; Tue, 05 Mar 2013 16:34:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UCuoh-0005yj-7F for pgsql-performance@arkaria.postgresql.org; Tue, 05 Mar 2013 16:34:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCuog-0005ye-CX for pgsql-performance@postgresql.org; Tue, 05 Mar 2013 16:34:14 +0000 Received: from nm32-vm6.bullet.mail.bf1.yahoo.com ([72.30.239.142]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UCuoZ-0001Lw-Bi for pgsql-performance@postgresql.org; Tue, 05 Mar 2013 16:34:13 +0000 Received: from [98.139.215.140] by nm32.bullet.mail.bf1.yahoo.com with NNFMP; 05 Mar 2013 16:34:05 -0000 Received: from [98.139.212.212] by tm11.bullet.mail.bf1.yahoo.com with NNFMP; 05 Mar 2013 16:34:04 -0000 Received: from [127.0.0.1] by omp1021.mail.bf1.yahoo.com with NNFMP; 05 Mar 2013 16:34:04 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 981038.81969.bm@omp1021.mail.bf1.yahoo.com Received: (qmail 44462 invoked by uid 60001); 5 Mar 2013 16:34:04 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1362501244; bh=FCb1IlmsB3nh3Eq+qovj6sKcSRve8i2Ii4KkbgxdCZI=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=3wYt9OfzE+bBY0sCm1KHdKqYkQ4ASdzvKPfI5wFsKjrsLSSgoTFYgvN9FqXevwTVwjPlXZbdVEY516PirNf23elzHIGe4/1j4OJgHO9CwkWVvk+p3ZWUHJtviIOSBESMhTEPpo9P5DJNjZLgpKrkiiP5JIL3pPsPqj1jnl0wf8k= 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:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Zvk2N+LwsEF49SbIbAvpod/aNuedw/L9E0J6zkOrCevWtO5a4qGsrlNMM0qA8m75APxOvKLoC4o8031CpeeYFfwDMN701pEZV1BBiFfA0iA50BLYVeudvwdGSl7mi5OebGM0yEojtPA/F4fBDIC/cNYgo4GjTpDPEQVjNR6eI4k=; X-YMail-OSG: t09e7EAVM1noX586LJ1BlKVezzY3U38jf6TU.sBVJPJIBpT cEe5Y.UJff3M.eUEWBUzu3eN9GCRxwuq2vpqDP6KdOmPKCZF9J6vVHYqi2sf emfAWwB_eeBIZMZE.nRhw7Ff1qY39nC6hvHYfGiFBwa9uxS9OyubU.2P8J1S tut.droLXK6Pf8_8QexgvF5YU4w.J2znm8ZjlaHlOZUQhfpktoU85MF7nd0a bXgIiKNsmKlElA65O6sVA.Jy9H2u7suZ.wtQKn1PbZSPuCBuEp9_IOyWx1j9 HRpHSVwdWmrPDhPSTCy6_ivBvCA6reWfetxgWjKrSUFVQfvuxdSKCUkUuFAc hg4Qkp8tbyqTqss2A_uXVc3CO1E6tFW5FYNvi2t77qn4zGdczn2XQWHZqprg oPWLz2zGdObCAO9_BHVHkdPN4h1eJLpCp2lQI2sSrGFUxSKTAa9SKRorP2Ct I3Nqjz0B3qPcr00z4Pb5iRC4BRrlIAM9nqv5TeL0wGQrAIAJw5jjMbUMKg7b izDCAsgq5fZAf6khPyjLkldvUzh9jMIY- Received: from [76.255.18.237] by web162905.mail.bf1.yahoo.com via HTTP; Tue, 05 Mar 2013 08:34:04 PST X-Rocket-MIMEInfo: 001.001, TmllbHMgS3Jpc3RpYW4gU2NoasO4ZHQgPG5pZWxza3Jpc3RpYW5AYXV0b3VuY2xlLmNvbT4gd3JvdGU6Cgo.IFNvIG15IHF1ZXN0aW9uIGlzLCBzaG91bGQgSSBhbHNvIGdldCBzb21ldGhpbmcgbGlrZSBwZ3Bvb2wyIHNldHVwCj4gYXQgdGhlIHNhbWUgdGltZT8gSXMgaXQsIGZyb20geW91ciBleHBlcmllbmNlLCBsaWtlbHkgdG8gaW5jcmVhc2UKPiBteSB0aHJvdWdocHV0IGEgbG90IG1vcmUsIGlmIEkgaGFkIGEgY29ubmVjdGlvbiBwb29sIG9mIGVnLiAyMAo.IGNvbm5lY3Rpb25zLCBpbnN0ZWFkIG9mIDMBMAEBAQE- X-Mailer: YahooMailWebService/0.8.135.514 References: <4D6D1410-2208-4DAA-BD64-69BE1FD94E55@autouncle.com> <06578781-EDBB-4BA9-B926-60491EBA5907@autouncle.com> Message-ID: <1362501244.18199.YahooMailNeo@web162905.mail.bf1.yahoo.com> Date: Tue, 5 Mar 2013 08:34:04 -0800 (PST) From: Kevin Grittner Reply-To: Kevin Grittner Subject: Re: New server setup To: =?iso-8859-1?Q?Niels_Kristian_Schj=F8dt?= , Craig James Cc: "pgsql-performance@postgresql.org" In-Reply-To: <06578781-EDBB-4BA9-B926-60491EBA5907@autouncle.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.0 (--) 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 Niels Kristian Schj=F8dt wrote: > 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? In my experience, it can make a big difference.=A0 If you are just using the pooler for this reason, and don't need any of the other features of pgpool, I suggest pgbouncer.=A0 It is a simpler, more lightweight tool. --=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