arcgis server connection pooling

Discussion created by dnc on Apr 15, 2013
Latest reply on Apr 18, 2016 by dnc
Hi there.

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?