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

Add BRIN indexes for timestamp columns

    XMLWordPrintable

    Details

      Description

      A number of edit-related tables have columns storing timestamps:

      • edit: open_time, expire_time, close_time
      • edit_note: post_time
      • vote: vote_time

      They have a strong correlation with the relevant ID column, but Postgres isn't aware of this fact. Adding BRIN indexes (introduced in 9.5) might help with this. In that case, existing btree indexes could probably be dropped.

        Attachments

          Issue Links

          has related issue

          Task - A task that needs to be done. MBS-8738 Make the edit search perform better

          • Normal - Loss of function, or other unwanted behavior.
          • Closed

            Activity

              People

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

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:

                  Packages

                  Version Package
                  Schema change, 2016-05-23