[Geoserver-devel] [JIRA] (GEOS-9055) Duplicate database index

[Damiano Albani (JIRA)]

Title: Message Title

Damiano Albani created an issue   GeoServer / GEOS-9055 Duplicate database index Issue Type: Improvement Assignee: Unassigned Attachments: image-2018-12-11-14-16-18-683.png, image-2018-12-11-14-18-11-588.png, image-2018-12-11-14-18-23-547.png Components: JDBCConfig Created: 11/Dec/18 2:21 PM Priority: Low Reporter: Damiano Albani The PgHero tool ("Performance dashboard for PostgreSQL") reports that there exists a duplicate index in the database: If I understand correctly, the object_property table defined an index: Which is redundant with: See DDL script at https://github.com/geoserver/geoserver/blob/master/src/community/jdbcconfig/src/main/resources/org/geoserver/jdbcconfig/internal/initdb.postgres.sql. The solution would be to simply omit the second index definition and the primary key index should be sufficient according to PgHero. 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#100095-sha1:b32a154)

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