Hi,
I am using a PostGIS database which servers 50 stores(in geoserver) and each
store contains around 7 layers(indexed). I could expect traffic(minimal) only
to
particular stores at a give time. I also expect that there wouldn't be more
than
"5 unique store" visitors at any point of time(total of 35 active connections).
My concern here is there would be several idle postgis/postgres connections
consuming up the RAM for stores just visited once and lying there for ever
until
I reach 100 connections limit from postgres.
If I limit the max connections in geoserver, I would end up thrashing
connections for each layer request within a store. Is it a good idea(in
general)
to limit the connections in postgres to 30-50 instead of default 100 for my
case? I just do not want to blow away my RAM for idle connections.
I have "Feature type cache size" in geoserver to maximum number of
features/layers.
Thanks,
Ravi.
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users