+ Reply to Thread
Results 1 to 2 of 2

Thread: arcgis server connection pooling

  1. #1
    Duarte Carreira
    Join Date
    Aug 2010
    Posts
    17
    Points
    0
    Answers Provided
    1


    0

    Default arcgis server connection pooling

    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?

    Thanks,
    Duarte

  2. #2
    Duarte Carreira
    Join Date
    Aug 2010
    Posts
    17
    Points
    0
    Answers Provided
    1


    0

    Default Re: arcgis server connection pooling

    Reporting my findings - might be useful to someone else.

    In fact it seems impossible to reduce the connections used by arcgis server, or arcgis desktop for that matter.

    Connections are always kept open with a transaction. So PgBouncer cannot optimize these connections. Why ESRI chooses to keep a transaction is unknown to me.

    Also, arcgis server opens 2 connections to PgSQL for every mapservice. So if you have 20 mapservices you'll have 40 connections open in PgSQL. Only when a service is shutdown due to innactivity timeout do you get its connections closed.

    This does not seem scalable at all to me. Maybe things will change in 10.2??

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts