From: Kevin Grittner <kgrittn@ymail.com>
To: Niels Kristian Schjødt <nielskristian@autouncle.com>
To: Craig James <cjames@emolecules.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: New server setup
Date: Tue, 5 Mar 2013 08:34:04 -0800 (PST)
Message-ID: <1362501244.18199.YahooMailNeo@web162905.mail.bf1.yahoo.com> (raw)
In-Reply-To: <06578781-EDBB-4BA9-B926-60491EBA5907@autouncle.com>
References: <4D6D1410-2208-4DAA-BD64-69BE1FD94E55@autouncle.com>
<CAFwQ8rcA7xuPLXLXxKnz6AGfTit0iwFByM9ypfe-GfQmH0rvDA@mail.gmail.com>
<06578781-EDBB-4BA9-B926-60491EBA5907@autouncle.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Niels Kristian Schjødt <nielskristian@autouncle.com> 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. 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.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kgrittn@ymail.com, nielskristian@autouncle.com, cjames@emolecules.com
Subject: Re: New server setup
In-Reply-To: <1362501244.18199.YahooMailNeo@web162905.mail.bf1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox