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" <[email protected]
>:
> 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 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 <[email protected]>:
>
>> 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
>>
>> 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
>> [email protected]https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>> --
>> Peter Kovac
>> IMS Programmer
>> [email protected]
>>
>> --
> -------------------------------------------------------------------
> Anton Lundkvist
> Malmö
> Tel: 0046 768 847 703
>
> --
> Peter Kovac
> IMS Programmer
> [email protected]
>
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
