abunchtell
/
mastodon
1
0
Fork 0
Code Issues 0 Activity
The code powering m.abunchtell.com https://m.abunchtell.com
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
8571 Commits
1 Branch
94 MiB
Branch: master
Branches Tags
${ item.name }
Create branch ${ searchTerm }
from 'master'
${ noResults }
mastodon/db/migrate/20171226094803_more_faster_...

20171226094803_more_faster_index_on_notifications.rb 315 B
Raw Permalink Normal View History

more faster index on notifications table (#6108)
6 years ago
Use disable_ddl_transaction! to prevent warnings on migration (#6183) Migration is wrapped by transaction, so manual `commit_db_transaction` without transaction restarting causes "there is no transaction in progress" warnings. We should use `disable_ddl_transaction!` instead, if we can omit transaction completely.
6 years ago
​
more faster index on notifications table (#6108)
6 years ago
​
​
​
​
 12345678 
  1. class MoreFasterIndexOnNotifications < ActiveRecord::Migration[5.1]

  2.   disable_ddl_transaction!

  3. 

  4.   def change

  5.     add_index :notifications, [:account_id, :id], order: { id: :desc }, algorithm: :concurrently

  6.     remove_index :notifications, name: :index_notifications_on_id_and_account_id_and_activity_type

  7.   end

  8. end