Thanks again Andrea.
I will let the group know if I come across any script or come up with something
on my own.
Thanks,
Ravi.
________________________________
From: Andrea Aime <andrea.a...@geo-solutions.it>
To: Ravi Pavuluri <ravith...@ymail.com>
Cc: "geoserver-users@lists.sourceforge.net"
<geoserver-users@lists.sourceforge.net>
Sent: Thursday, April 21, 2011 12:09 PM
Subject: Re: [Geoserver-users] Geoserver Migration+ PostGIS(JNDI)
On Thu, Apr 21, 2011 at 6:02 PM, Ravi Pavuluri <ravith...@ymail.com> wrote:
Andrea,
>
>
>Thank you for your response. Let me put it in a different way.
>
>
>PostGIS Database Server has 45+ databases and tables(imported shapefiles) are
>stored in default "public" schema. Each database has 8-10 tables. When I
>create PostGIS connection to a database using GeoServer interface, I limit max
>connections to that database as 8.
>
>
>Based on your reply, I think it is where the connection pooling is enabled. Am
>I correct?
>
Correct. With this setup you have at most 45 * 8 open connections: 360.
>
>Looks like JNDI doesn't help with my data organization.
>
>
>
>I will have to restructure my data to put them in different schemas in the
>same database. Correct?
>
>Is there any script(s)/mechanism that help me to re-publish my data to make
>use of JNDI?
>
Not aware of any, you might want to search on Google.
>
>I check the RAM usage using "Webmin" module where approx 2GB of RAM is given
>to Java/Tomcat/GeoServer followed by the list of processes(sample provided
>below). There is a significant amount of styling for each of the layers.
>
>
>
>PID Owner Size Command
>
>32426
> pgsql 87580 kB postgres: postgres MyLayer1 127.0.0.1(33444) idle
>
>
>"Size" is what telling me the RAM usage(Correct me if I am wrong). The
>connections are made and you can see they become idle very soon after they are
>made.May be they are sitting in the buffer pool of DB? I do not check the
>"HTTP Caching" option while publishing the data layers.
>
They are sitting in the pool, that's what the pool is for: keeping connections
open to avoid
the (significant) overhead involved in closing and opening them.
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
