diff options
author | Yorick Peterse <yorickpeterse@gmail.com> | 2018-03-12 12:47:06 +0000 |
---|---|---|
committer | Robert Speicher <rspeicher@gmail.com> | 2018-03-13 10:45:11 -0500 |
commit | e54d3a483c44aa581d884ddeb0d58fd2b3cb3c60 (patch) | |
tree | 3137443b3f5ca32d28add9c41d86e9ecd10229ec /db/schema.rb | |
parent | 4f4e97a2895778f44dffd5104cea5b6f452603bd (diff) | |
download | gitlab-ce-e54d3a483c44aa581d884ddeb0d58fd2b3cb3c60.tar.gz |
Merge branch 'add-indexes-to-todos-for-heavy-users-like-sean' into 'master'
Add partial indexes on todos to handle users with many todos
See merge request gitlab-org/gitlab-ce!17668
Diffstat (limited to 'db/schema.rb')
-rw-r--r-- | db/schema.rb | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/db/schema.rb b/db/schema.rb index 75a094bbbb6..ab4370e2754 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20180308052825) do +ActiveRecord::Schema.define(version: 20180309160427) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" @@ -1778,6 +1778,8 @@ ActiveRecord::Schema.define(version: 20180308052825) do add_index "todos", ["note_id"], name: "index_todos_on_note_id", using: :btree add_index "todos", ["project_id"], name: "index_todos_on_project_id", using: :btree add_index "todos", ["target_type", "target_id"], name: "index_todos_on_target_type_and_target_id", using: :btree + add_index "todos", ["user_id", "id"], name: "index_todos_on_user_id_and_id_done", where: "((state)::text = 'done'::text)", using: :btree + add_index "todos", ["user_id", "id"], name: "index_todos_on_user_id_and_id_pending", where: "((state)::text = 'pending'::text)", using: :btree add_index "todos", ["user_id"], name: "index_todos_on_user_id", using: :btree create_table "trending_projects", force: :cascade do |t| |