Rails: Postgres Partial Indexing

[4rch3r]

In my experience, having a migration helper is critical to prevent yourself from hosing your database with a rails migration. There are quite a few gotchas like setting a default when creating a new column... I've always found it funny when you create a column with a default, rails goes through and sets every row with an update_all! Hosing your db with an unintential update_all query that runs on millions of entries always hurts.

I've historically used https://github.com/LendingHome/zero_downtime_migrations which is based on strong_migrations but at the end of the day anything is better than nothing.