Hi Anton,
sorry, for late response: in my experience this is something you have to
try and adjust yourself, because every computer setup is different. You
can use e.g. Apache JMeter to create a bunch of testing WMS requests and
then try to find the setting where you have the best performance. You
may find out you are not bounded by database, but network or disk access...
Cheers,
Peter
On 1. 11. 2016 17:08, Anton Lundkvist wrote:
Thanks for the info!
I finally had the time to implement the Jindi connection pooling. It
seems to work well.
I configured according to the geoserver docs.
http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html
Do you have any info on what the different configuration settings in
the context.xml stand for or if there are any additional setting I
should set to maximize performance? I use tomcat 8 and checked the
docs there but did not find much.
For example I would like to know what the
maxActive="20"
maxIdle="8"
In the context.xml does. Does the connection pool allow adding
unlimited amount of feature types to that store or are there still
limits to what it can handle?
My database is configured to accept unlimited amounts of connections
Thanks again for the help!
Anton
Den 29 sep. 2016 8:27 AM skrev "Peter Kovac"
<peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>>:
Hi Anton,
Please, keep the conversation on the mailing list so others can
help you or benefit from our conversation.
I don't use gsconfig, so I'm not able to help you with it.
However, once you set up your PostGIS JNDI datastore, it's just
another datastore and I wildly guess that gsconfig will work
happily with it.
In my opinion setting up JNDI manually is just a small effort for
a very high reward.
Cheers,
Peter
On 28. 9. 2016 10:40, Anton Lundkvist wrote:
Ok thanks!
I'm relying heavily on gsconfig.py
https://github.com/boundlessgeo/gsconfig
<https://github.com/boundlessgeo/gsconfig> for publishing my
tables. I haven't found any info on if it is possible to use JNDI
with gsconfig. Does anyone know?
regards,
anton
2016-09-28 9:15 GMT+02:00 Peter Kovac
<peter.ko...@microstep-mis.com
<mailto:peter.ko...@microstep-mis.com>>:
Hi Anton,
If you are using Apache Tomcat or another container I
recommend using JNDI connection pooling. That way you have 1
connection pool shared among all of your layers and you can
manage it easily. I observed significant performance gains
when switching from "PostGIS" to "PostGIS (JNDI)" type of
store (database connections don't have to be recreated with
each request and it saves a lot of time). It works with
ImageMosaic datastores with custom dimensions too.
http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html
<http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html>
Cheers,
Peter
On 28. 9. 2016 8:57, Anton Lundkvist wrote:
Hi GeoServer Users:
I'm using GeoServer for serving vector data (from PostGis).
Keeping the number of stores down e.g. many layers per store
reduces the number of connections to PostGis. This is
desirable as I have hundreds of tables that are published
through GeoServer.
Is there a recommended limit for how many layers /
resources I should handle with one store?
Regards,
Anton Lundkvist
------------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
<https://lists.sourceforge.net/lists/listinfo/geoserver-users>
--
Peter Kovac
IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com
<mailto:peter.ko...@microstep-mis.com>
--
-------------------------------------------------------------------
Anton Lundkvist
Malmö
Tel: 0046 768 847 703
--
Peter Kovac
IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com <mailto:peter.ko...@microstep-mis.com>
--
Peter Kovac
IMS Programmer
MicroStep-MIS
peter.ko...@microstep-mis.com
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users