I'm looking at reducing number of connections from ArcGIS Server 10 services to a PostgreSQL 8.4 geodatabase.
I'm seeing 2 connections per map service. These connections appear as "<IDLE> in transaction", ie they are not doing anything.
My question is how to reduce the number of connections. Is there a configuration setting I can use?
Also, has anyone used PgBouncer with ArcGIS Server?