What I'm trying to determine is: should I plan on using pgbouncer?
With Rails & Passenger, do the app server processes take and hold connections to the db? Or take & release with
queries/connections?
This is not a scalability question; given the traffic the site will have I only need a small handful of connections.
It'sa latency question, I don't want to be starting up new pg processes excessively.
(Yes, I thought about asking on the RoR list, since it's really a question about RoR behaviors, but on the other hand
itinvolves pg optimization & best practice, which is, ahem, different than with MySQL.)
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice