Roope,
> Date: Wed, 26 Sep 2012 10:53:15 +0300
> From: roope.te...@fmi.fi
> To: geoserver-users@lists.sourceforge.net
> Subject: [Geoserver-users] postgis connection limit and performance
>
> Hello
>
> We have a setup with about 100 image mosaic data stores which all use
> postgis database. At the moment every data store have maximum 5
> connections. Now we have a problem with too many connections to the
> database. Does anyone have any experience, is it safe to decrease
> connections to 1 per store or does it affect to the performance?
Don't think this is a good option.Have you configured connections using
jndi?http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html
Are you using a connection
pool?http://docs.geoserver.org/stable/en/user/data/database/connection-pooling.html
It is highly recommended to use a connection pool which may help you to reuse
open connections.
Cheers,Carlo
>
> best regards
> Roope
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
