[Geoserver-devel] [JIRA] (GEOS-9088) OR performance issue with complex subqueries on app-schema with postgis datasource

[JIRA]

Title: Message Title

Fernando Miño created an issue   GeoServer / GEOS-9088 OR performance issue with complex subqueries on app-schema with postgis datasource Issue Type: Improvement Assignee: Fernando Miño Components: Application schema Created: 08/Jan/19 3:35 PM Priority: Medium Reporter: Fernando Miño Is known that OR queries are difficult to optimize for postgresql and are usually slow. The fix for slow queries with OR involved is using UNION queries, so we need optimize certain complex subqueries. The slow appschema subquery involved is that generated by NestedFilterToSQL class so we need to change the use of OR clause in the root condition for UNION queries. Since this performance issue affect postgresql, the fix should be isolated for this datasource only, and adding a system property for disable. We'll need execute online tests with postgresql and geoserver-appschema with new improvement enabled and disabled. Add Comment   Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100097-sha1:6c72860)

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel