most likely cause is that you have saturated the postgis connection pool
and are waiting for earlier requests to complete.
I can't think of anything else obvious that might cause that problem.
Ian
On 12 May 2016 at 13:08, Jonathan Moules <jonathan-li...@lightpear.com>
wrote:
> Hi List,
> Doing some performance testing (WMS GetMap) on a GeoServer (2.7.2)
> with PostGreSQL (9.5.2) using JMeter, we're getting some odd slowdowns. It
> seems that for a short while (up to a few minutes) GeoServer massively
> slows down in responding to requests; the "max" times shoot up from a few
> seconds to about 60-70 seconds! We've had this across several environments
> with PostGres, but the same tests on Oracle have never exhibited this.
> The issue isn't on the PostGres end - the slowest query there during
> the tests takes about 4 seconds, there's no queuing and the resource usage
> on its (separate to GeoServer) box is negligible.
> If I make the same request to GeoServer directly when not part of this
> testing, it only takes a second or two, so there's nothing obviously wrong
> with the requests either. The problem is also proving difficult to
> replicate reliably.
> The connections to PG are via Tomcat using a JNDI pool.
> Has anyone encountered this sort of behaviour before or have any
> inkling as to the cause?
> Thanks,
> Jonathan
>
>
> ------------------------------------------------------------------------------
> Mobile security can be enabling, not merely restricting. Employees who
> bring their own devices (BYOD) to work are irked by the imposition of MDM
> restrictions. Mobile Device Manager Plus allows you to control only the
> apps on BYO-devices by containerizing them, leaving personal data
> untouched!
> https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
Ian Turton
------------------------------------------------------------------------------
Mobile security can be enabling, not merely restricting. Employees who
bring their own devices (BYOD) to work are irked by the imposition of MDM
restrictions. Mobile Device Manager Plus allows you to control only the
apps on BYO-devices by containerizing them, leaving personal data untouched!
https://ad.doubleclick.net/ddm/clk/304595813;131938128;j
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
