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

Add BRIN indexes for timestamp columns

XMLWordPrintable

      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.

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

              Created:
              Updated:
              Resolved:

                Version Package
                Schema change, 2016-05-23