Re: Migrated from 8.3 to 9.0 - need to update config (re-post)

From: Carlo Stonebanks [mailto:stonec(dot)register(at)sympatico(dot)ca]
Sent: Tuesday, September 13, 2011 9:27 PM
To: Performance support Postgresql
Subject: Re: Migrated from 8.3 to 9.0 - need to update config (re-post)

 
________________________________________
Ok, connection pooler it is. As I understand it, even if there are no idle connections available we'll get the benefit of putting a turnstile on the butcher's door.
I also ordered the book as soon as you mentioned - the title alone was enough to sell me on it! The book won't be for the errant sys admin who increased the connections, it's for me - I'll use it to whack the sys admin on the head. Thanks fo rthe tip, the author owes you a beer - as do I.
 
Will the book recommend any particular connection pooler product, or is it inappropriate to ask for a recommendation on the forum?
 
Carlo
 

I'd start with the pg_bouncer: very simple to setup, reliable, no "extra" functionality, which seems by your message you don't need.

Igor Neyman