Good idea... with full details to reproduce on a developer machine, like
the table demotion, sample data, style and request.
Cheers
Andrea
Il 15 lug 2016 15:56, "Simon Hartley" <[email protected]> ha scritto:
Should I file this in JIRA as a regression?
Simon
*From:* Simon Hartley [mailto:[email protected]]
*Sent:* 12 July 2016 17:36
*To:* [email protected]
*Subject:* [EXTERNAL][Geoserver-users] GeoServer upgrade issue from 2.2.5
I have a WMS layer using a Rendering Transformation for a parameterized SQL
View layer (which calls a database function).
Upgrading from an old version of GeoServer we’ve experienced a massive
performance problem with this layer.
When setting logging to verbose, the old version produced SQL something
like:
SELECT encode(ST_AsBinary(ST_Force_2D("location")),'base64') as
"location","myval" FROM (select location, thevalue as myval
from myschema.get_data( 70,50 )) as "vtable" WHERE "location" &&
ST_GeomFromText('POLYGON ((-26.823634473210518 6.409727748826477,
-26.823634473210518 33.560993640777525, 0.3276314187394202
33.560993640777525, 0.3276314187394202 6.409727748826477,
-26.823634473210518 6.409727748826477))', 4326)
The new version shows:
SELECT encode(ST_AsEWKB("location"),'base64') as "location","myval" FROM
(select location, thevalue as myval from myschema.get_data( 70,50 )) as
"vtable"
The lack of spatial filter causes a huge performance problem since about
100 times as many rows are returned and the Barnes Surface transformation
gobbles up all the CPU and GeoServer becomes unresponsive.
Any thoughts about what could be causing the spatial filter to no longer be
added?
What I’ve read in other threads hasn’t really made this clear to me.
Thanks,
Simon Hartley
.
*** This communication has been sent from World Fuel Services
Corporation or its subsidiaries or its affiliates for the intended
recipient
only and may contain proprietary, confidential or privileged information.
If you are not the intended recipient, any review, disclosure, copying,
use, or distribution of the information included in this communication
and any attachments is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to this
communication and delete the communication, including any
attachments, from your computer. Electronic communications sent to or
from World Fuel Services Corporation or its subsidiaries or its affiliates
may be monitored for quality assurance and compliance purposes.***
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning
reports.http://sdm.link/zohodev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
