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

Evaluate index definitions in light of index-only scans

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Schema Change
    • Labels:
      None

      Description

      Postgres 9.2+ supports index-only scans. This means that it can be useful to have indexes with additional columns that aren't used as predicates, if that allows using an index-only scan for some join. We should go through the potentially affected queries and check whether extending an index might improve performance.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                chirlu Ulrich Klauer
                Reporter:
                chirlu Ulrich Klauer
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:

                  Packages

                  Version Package