#concurrent

PostgreSQL Concurrent Indexes in Rails: Avoiding Downtime in Production

When working with large production databases, adding an index may seem like a simple migration. However, on tables with millions of records, a regular index creation can lock writes and impact your application's availability.