diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/tableattrs.sql | 2 | ||||
-rw-r--r-- | util/updates/update_wip_lists.sql | 2 |
2 files changed, 4 insertions, 0 deletions
diff --git a/util/sql/tableattrs.sql b/util/sql/tableattrs.sql index a63b2fcd..54361c0a 100644 --- a/util/sql/tableattrs.sql +++ b/util/sql/tableattrs.sql @@ -134,6 +134,8 @@ CREATE INDEX votes_uid ON votes (uid); CREATE UNIQUE INDEX changes_itemrev ON changes (type, itemid, rev); CREATE UNIQUE INDEX chars_vns_pkey ON chars_vns (id, vid, COALESCE(rid, 0)); CREATE UNIQUE INDEX chars_vns_hist_pkey ON chars_vns_hist (chid, vid, COALESCE(rid, 0)); +CREATE INDEX ulist_vns_voted ON ulist_vns (vid, vote_date) WHERE vote IS NOT NULL; -- For VN recent votes & vote graph. INCLUDE(vote) speeds up vote graph even more +CREATE INDEX users_ign_votes ON users (id) WHERE ign_votes; diff --git a/util/updates/update_wip_lists.sql b/util/updates/update_wip_lists.sql index a327f854..c07e4ba1 100644 --- a/util/updates/update_wip_lists.sql +++ b/util/updates/update_wip_lists.sql @@ -129,3 +129,5 @@ ALTER TABLE users ADD COLUMN c_wish integer NOT NULL DEFAULT 0; \timing SELECT update_users_ulist_stats(NULL); +CREATE INDEX ulist_vns_voted ON ulist_vns (vid, vote_date) WHERE vote IS NOT NULL; +CREATE INDEX users_ign_votes ON users (id) WHERE ign_votes; |