Alessandro Parma ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A5fdc9473-7545-431c-ac32-72504f96e54b ) *created* an issue
GeoServer ( https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiYTU0YjY2ZDVkMTMyNGVkNzkyNWExNjFiYTc3Nzg4ZmYiLCJwIjoiaiJ9 ) / Improvement ( https://osgeo-org.atlassian.net/browse/GEOS-10041?atlOrigin=eyJpIjoiYTU0YjY2ZDVkMTMyNGVkNzkyNWExNjFiYTc3Nzg4ZmYiLCJwIjoiaiJ9 ) GEOS-10041 ( https://osgeo-org.atlassian.net/browse/GEOS-10041?atlOrigin=eyJpIjoiYTU0YjY2ZDVkMTMyNGVkNzkyNWExNjFiYTc3Nzg4ZmYiLCJwIjoiaiJ9 ) Add DB index to OSEO community module schema ( https://osgeo-org.atlassian.net/browse/GEOS-10041?atlOrigin=eyJpIjoiYTU0YjY2ZDVkMTMyNGVkNzkyNWExNjFiYTc3Nzg4ZmYiLCJwIjoiaiJ9 ) Issue Type: Improvement Affects Versions: 2.19-RC Assignee: Alessandro Parma ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A5fdc9473-7545-431c-ac32-72504f96e54b ) Attachments: image-2021-04-28-11-04-49-112.png, image-2021-04-28-11-05-14-028.png Components: Community modules Created: 28/Apr/21 11:08 AM Priority: Low Reporter: Alessandro Parma ( https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A5fdc9473-7545-431c-ac32-72504f96e54b ) While trying to help one of our clients with speeding up spatial queries opensearch schema I found adding a multicolumn index on product(eoParentIdentifier, timeStart, timeEnd) to speed up opensearch requests. Specifically, the completion time for one of the requests performed by GeoServer while serving WMS GetMap requests went down from 1.2 seconds to 23 ms: Before ( https://osgeo-org.atlassian.net/secure/attachment/33688/33688_image-2021-04-28-11-04-49-112.png ) After: ( https://osgeo-org.atlassian.net/secure/attachment/33687/33687_image-2021-04-28-11-05-14-028.png ) The table has 27M tuples Index creation query is: CREATE INDEX super_idx ON product( "eoParentIdentifier" , "timeEnd" , "timeStart" ) I'm going to sumbit a pull request to update the OSEO schema initialization script ( https://raw.githubusercontent.com/geoserver/geoserver/main/src/community/oseo/oseo-core/src/test/resources/postgis.sql ) ( https://osgeo-org.atlassian.net/browse/GEOS-10041#add-comment?atlOrigin=eyJpIjoiYTU0YjY2ZDVkMTMyNGVkNzkyNWExNjFiYTc3Nzg4ZmYiLCJwIjoiaiJ9 ) Add Comment ( https://osgeo-org.atlassian.net/browse/GEOS-10041#add-comment?atlOrigin=eyJpIjoiYTU0YjY2ZDVkMTMyNGVkNzkyNWExNjFiYTc3Nzg4ZmYiLCJwIjoiaiJ9 ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100157- sha1:728765f )
_______________________________________________ Geoserver-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-devel
