JDBCConfig - duplicate database index

Description

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.

Environment

None

Assignee

Steve Ikeoka

Reporter

Damiano Albani

Triage

None

Fix versions

Affects versions

None

Components

Priority

Low
Configure