diff options
| author | Zettat123 <zettat123@gmail.com> | 2023-03-24 23:44:33 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-03-24 23:44:33 +0800 |
| commit | b958dba1a0f84b986acdb82a6609d70d98140640 (patch) | |
| tree | e1dae37308862c147577b639f26cad1fe92e24c2 /models/activities | |
| parent | e52ea44edd99e6ec1c5567c78e663802cdf3cf91 (diff) | |
| download | gitea-b958dba1a0f84b986acdb82a6609d70d98140640.tar.gz gitea-b958dba1a0f84b986acdb82a6609d70d98140640.zip | |
Improve indices for `action` table (#23532)
Close #21611
Add the index mentioned in
https://github.com/go-gitea/gitea/issues/21611#issuecomment-1451113252 .
Since we already have an index for `("created_unix", "user_id",
"is_deleted")` columns on PostgreSQL, I removed the database type check
to apply this index to all types of databases.
Diffstat (limited to 'models/activities')
| -rw-r--r-- | models/activities/action.go | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/models/activities/action.go b/models/activities/action.go index c1d17517ba..4111d8098b 100644 --- a/models/activities/action.go +++ b/models/activities/action.go @@ -98,12 +98,10 @@ func (a *Action) TableIndices() []*schemas.Index { actUserIndex := schemas.NewIndex("au_r_c_u_d", schemas.IndexType) actUserIndex.AddColumn("act_user_id", "repo_id", "created_unix", "user_id", "is_deleted") - indices := []*schemas.Index{actUserIndex, repoIndex} - if setting.Database.Type.IsPostgreSQL() { - cudIndex := schemas.NewIndex("c_u_d", schemas.IndexType) - cudIndex.AddColumn("created_unix", "user_id", "is_deleted") - indices = append(indices, cudIndex) - } + cudIndex := schemas.NewIndex("c_u_d", schemas.IndexType) + cudIndex.AddColumn("created_unix", "user_id", "is_deleted") + + indices := []*schemas.Index{actUserIndex, repoIndex, cudIndex} return indices } |