Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-11641

Drop redundant ${entity}_rating_raw_idx_${entity} indices

    XMLWordPrintable

    Details

      Description

      As mentioned by Michael Wiencek on the PR for MBS-11451, these indices are redundant with the primary key indices for the rating_raw tables, so they can be dropped. (PostgreSQL automatically creates a unique index for primary keys, and the primary key here already has the entity{{}} as the left-most column.)

        Attachments

          Activity

            People

            Assignee:
            reosarevok Nicolás Tamargo
            Reporter:
            reosarevok Nicolás Tamargo
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Packages

                Version Package
                Schema change, 2021 Q2