On Thu, Apr 21, 2011 at 12:38 AM, Ravi Pavuluri <[email protected]> wrote: > Hi All, > > We are using 450+ vector layers(45+ databases) in PostGIS database served > through GeoServer(2.0.2) most of which is WMS. Given the way it is, RAM is > being used up ~60-100MB per layer(expected traffic is not very high as of > now).We may hit the RAM limit if traffic becomes higher, since there is no > queuing mechanism for total PostGIS connections . No such problem with RAM > was encountered with shapefiles, though they are not recommended in > production. We have not tried PostGIS (JNDI) but I read it that helps in > connection pooling.
I don't follow... the PostGIS connection pool has a maximum configurable number of connections. If you say the max is 20 every request trying to get the 21th connection will be queued. That said, with 45 databases I guess you have a very large number if you sum the max number of connections. Is it GeoServer or the postgis processes that are consuming most of the memory? I'm also puzzled as to how you computed that 60-100MB per layer memory consumption. The memory required by WMS is largely dependent on the number of requests going, their size, and the styling used, it's not something statically depending on the number of layers. > 1) What is the best way to have all the databases from the "same" PostGIS > schema to JNDI connections? Any estimate of how much(time) of an effort that > would be? JNDI helps if you have one database with 45 different schemas, if you have 45 phisically separate databases I don't believe you can setup a single connection pool to talk with them. > 2) Also, what would be the best way to migrate all of them to a stable > version of GeoServer 2.1(whenever available)? Does combining JNDI > connections and GeoServer 2.1 migration save time if we do them together? > > Any additional documentation on JNDI connection is appreciated. We have a tutorial here: http://docs.geoserver.org/2.0.0/user/tutorials/tomcat-jndi/tomcat-jndi.html Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ Benefiting from Server Virtualization: Beyond Initial Workload Consolidation -- Increasing the use of server virtualization is a top priority.Virtualization can reduce costs, simplify management, and improve application availability and disaster protection. Learn more about boosting the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
