From dc1ebd45a30d806fcef2dc33679457285ba430b4 Mon Sep 17 00:00:00 2001 From: takayamaki Date: Thu, 30 Nov 2017 11:35:54 +0900 Subject: add index on stream_entries table (#5793) --- db/migrate/20171129172043_add_index_on_stream_entries.rb | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 db/migrate/20171129172043_add_index_on_stream_entries.rb (limited to 'db/migrate') diff --git a/db/migrate/20171129172043_add_index_on_stream_entries.rb b/db/migrate/20171129172043_add_index_on_stream_entries.rb new file mode 100644 index 000000000..478530c7f --- /dev/null +++ b/db/migrate/20171129172043_add_index_on_stream_entries.rb @@ -0,0 +1,7 @@ +class AddIndexOnStreamEntries < ActiveRecord::Migration[5.1] + def change + commit_db_transaction + add_index :stream_entries, [:account_id, :activity_type, :id], algorithm: :concurrently + remove_index :stream_entries, name: :index_stream_entries_on_account_id + end +end -- cgit