Add concurrent index in Postgres Rails migration

index_users_emails.rb

class IndexUsersEmails < ActiveRecord::Migration
  def ddl_transaction(&block)
    block.call # do not start a transaction
  end

  def self.up
    execute "CREATE INDEX CONCURRENTLY index_users_on_email ON users(email)"
  end
end

Thank you for this! Have you had any problems with it since you wrote this?

Another quick question. Why not put the execute END/BEGIN inside the add_pg_index method?

I'm guessing that's a hack to break out of the transaction? http://robots.thoughtbot.com/post/56828751507/how-to-create-postgres-indexes-concurrently-in