|
|
Fernando Miño created an issue |
|
OR performance issue with complex subqueries on app-schema with postgis datasource |
|
Issue Type: |
|
|---|---|
|
Assignee: |
|
|
Components: |
Application schema |
|
Created: |
08/Jan/19 3:35 PM |
|
Priority: |
|
|
Reporter: |
|
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. |
|
|
|
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) |
|
|
|