From 91b9514aafbefd5c9c10380878bef1b03245d10c Mon Sep 17 00:00:00 2001 From: Christopher Speller Date: Fri, 27 Oct 2017 06:02:16 -0700 Subject: Adding Posts table indexes for 20M rows. (#7728) --- store/sqlstore/post_store.go | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'store/sqlstore/post_store.go') diff --git a/store/sqlstore/post_store.go b/store/sqlstore/post_store.go index d8f93d2bc..6faf51c3d 100644 --- a/store/sqlstore/post_store.go +++ b/store/sqlstore/post_store.go @@ -11,6 +11,7 @@ import ( "strings" "bytes" + l4g "github.com/alecthomas/log4go" "github.com/mattermost/mattermost-server/einterfaces" "github.com/mattermost/mattermost-server/model" @@ -73,6 +74,9 @@ func (s SqlPostStore) CreateIndexesIfNotExists() { s.CreateIndexIfNotExists("idx_posts_user_id", "Posts", "UserId") s.CreateIndexIfNotExists("idx_posts_is_pinned", "Posts", "IsPinned") + s.CreateCompositeIndexIfNotExists("idx_posts_channel_id_update_at", "Posts", []string{"ChannelId", "UpdateAt"}) + s.CreateCompositeIndexIfNotExists("idx_posts_channel_id_delete_at_create_at", "Posts", []string{"ChannelId", "DeleteAt", "CreateAt"}) + s.CreateFullTextIndexIfNotExists("idx_posts_message_txt", "Posts", "Message") s.CreateFullTextIndexIfNotExists("idx_posts_hashtags_txt", "Posts", "Hashtags") } -- cgit v1.2.3-1-g7c22