Niels Kristian Schjødt <nielskrist...@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