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

Evaluate index definitions in light of index-only scans

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Unresolved
    • Icon: Normal Normal
    • None
    • None
    • Schema Change
    • None

      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.

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

              Created:
              Updated:

                Version Package