active_record 往已有表添加jsonb column很慢的问题

最新推荐文章于 2022-06-09 16:30:06 发布

i自由

最新推荐文章于 2022-06-09 16:30:06 发布

阅读量235

点赞数

本文链接：https://blog.csdn.net/WoBenZiYou/article/details/101730691

版权

https://blog.bitwrangler.com/2016/11/30/performant-postgres-migrations.html

slow

class AddInfoColumnToCaseDocketReport < ActiveRecord::Migration
  def change
    add_column :case_docket_reports, :info, '{}'
  end
end

faster

Add columns without default values

class AddInfoColumnToCaseDocketReport < ActiveRecord::Migration
  def change
    add_column :case_docket_reports, :info, :jsonb
    change_column_default :case_docket_reports, :info,  '{}'
  end
end

并行往postgres添加index的问题解决，快且不阻塞

class AddIndexToAsksActive < ActiveRecord::Migration
  disable_ddl_transaction!

  def change
    add_index :asks, :active, algorithm: :concurrently
  end
end