Re: New server setup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Niels Kristian Schjødt <nielskristian@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux