Re: New server setup - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: New server setup
Date
Msg-id CAOR=d=3_KXQnE9PwMnmGJaVQ_8EVZietjjra1XR7iU2n8FDxKw@mail.gmail.com
Whole thread Raw
In response to Re: New server setup  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-performance
On Tue, Mar 5, 2013 at 9:34 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
> 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.

I second the pgbouncer rec.


pgsql-performance by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: New server setup
Next
From: Niels Kristian Schjødt
Date:
Subject: Re: New server setup