On Thu, 2009-01-08 at 12:51 -0700, Gregory Williamson wrote: > Thom Brown wrote: > <...> > > I actually mentioned pgPool II to my boss earlier, and it's > something we > > will have to seriously consider, but will have to do some research > first. > > We had an application ported from Informix which initially required > 1000+ connections to handle peak load (one of 4 servers pushed by two > application servers doing spatial queries). > > Using pgPool means we have a max limit of 100 and have almost never > gone near it -- usually we have 12-25 connections at once and load and > throughput are higher than they were before.
Not to disparage pgPool, but we have also had great results with pgBouncer. Joshua D. Drake > -- PostgreSQL Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
