Hi list,
I have an imagepyramid made of of 16 imagemosaic layers.
The imagemosaic indexes are stored in a postgis database.
I've had connection exhaustion problems (i.e. "sorry, too many clients" from the PostgreSQL backend).

My guess is that even though the imagepyramid has its own datastore.properties file, each imagemosaic layer uses the "max\ connections" parameter from its own datastore.properties file. So for 16 imagemosaic layers with the default max connections setting (10), we could go as high as 160 idle open connections.

Is this assumption correct ? If I am right, then the only way to keep these connections at a reasonable level would be to set the max connections per imagemosaic to something like 4 or 5.

Thanks for your advices on this !


Cheers !

--
Arnaud


_______________________________________________
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to