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

Damiano Albani created an issue

GeoServer / ImprovementGEOS-9055

Duplicate database index

Issue Type:

ImprovementImprovement

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:

LowLow

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

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)

Atlassian logo