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

Add BRIN indexes for timestamp columns

    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

            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: