Thanks for answers! I have been loaded with other jobs and didn't have time to check this. I'll have a look soon and keep you informed.
Roope -----Original Message----- From: simbo...@gmail.com [mailto:simbo...@gmail.com] On Behalf Of Simone Giannecchini Sent: 27. syyskuuta 2012 16:01 To: Roope Tervo Cc: geoserver-users@lists.sourceforge.net Subject: Re: [Geoserver-users] postgis connection limit and performance Ciao Roope, I would suggest to set up a JNDI datasource and then connect to it with a proper datastore.properties as explained here: http://geobatch.geo-solutions.it/download/latest/doc/actionImageMosaic.html#using-jndi-on-postgis Regards, Simone Giannecchini == Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information. == Ing. Simone Giannecchini @simogeo Founder/Director GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 333 8128928 http://www.geo-solutions.it http://twitter.com/geosolutions_it ------------------------------------------------------- On Wed, Sep 26, 2012 at 9:53 AM, Roope Tervo <roope.te...@fmi.fi> wrote: > 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? > > 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 ------------------------------------------------------------------------------ Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
