[Geoserver-devel] [JIRA] (GEOS-7500) ImageMosaic creation/update very slow when database has many tables

Matt Bertrand created an issue

GeoServer / BugGEOS-7500

ImageMosaic creation/update very slow when database has many tables

Issue Type:

BugBug

Assignee:

Unassigned

Created:

15/Apr/16 6:54 PM

Environment:

Ubuntu 14.04, OS X

Priority:

MediumMedium

Reporter:

Matt Bertrand

After upgrading Geoserver from 2.7.4 to 2.8.2, updating existing image mosaics or creating new ones (with configuration saved in a PostGIS DB having thousands of other tables) became extremely slow and hung up other Geoserver until completed. I tracked the problem down to this line in Geotools, which causes every table in the database to be examined.

I am not sure if this is working as designed, but a workaround is to add “TypeNames=false” to the image mosaic’s datastore.properties file, which will prevent this code block from being called. This should probably be included in the ImageMosaic documentation.

Add Comment

Add Comment

This message was sent by Atlassian JIRA (v7.2.0-OD-05-030#72002-sha1:7e8526a)

Atlassian logo