Marcello, Maybe it's time to talk about doing a master/slave replication configuration of postgres to handle the database load. If you want, contact me off list and I'd be willing to help any way I can. -brandon Marcello Perathoner wrote:
Brandon Galbraith wrote:
Could connection pooling fix this? Maybe combined with more concurrent connections to the database server? I'm not sure how big the database box is though.
I'm not sure why the limit is so low. Maybe the folks at ibiblio have a good reason for it. We have to see what increasing the number of concurrent connections does to query response time.
The database box is a dual-processor IBM whatever. I can look up the specs if you want. But this box and his brother are serving all sites hosted at ibiblio. Many of those sites are build with CMS and thus very database intensive.