30 Jul '13, 12am

How to Create Postgres Indexes Concurrently in ActiveRecord Migrations

How to Create Postgres Indexes Concurrently in ActiveRecord Migrations Posted by croaky on July 30, 2013 — 0 comments By default, Postgres locks writes (but not reads) to a table while creating an index on it. That can result in unacceptable downtime during a production deploy. On a large table, indexing can take hours. However, ActiveRecord 4 makes it easy to create Postgres indexes concurrently and avoid accidental downtime caused by long, write-blocking database indexing.

Full article: http://www.rubyflow.com/items/9623-how-to-create-postgres...

Tweets

How to Create Postgres Indexes Concurrently in ...

robots.thoughtbot.com 30 Jul '13, 12am

July 29, 2013 dancroak postgres activerecord How to Create Postgres Indexes Concurrently in ActiveRecord Migrations By def...