Details
-
Type:
Task
-
Status: Closed
-
Priority:
Normal
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: Schema change, 2016-05-23
-
Component/s: Schema Change
-
Labels:None
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
-
MBS-8738 Make the edit search perform better
-
- Closed
-