---
title: "Discussion on \"PostgreSQL Concurrent Indexes in Rails: Avoiding Downtime in Production\" | Hashnode"
description: "Discussion on \"PostgreSQL Concurrent Indexes in Rails: Avoiding Downtime in Production\". When working with large production databases, adding an index may seem like a simple migration.\n\nHowever, on tables with millions of records, a regular index creation can lock writes and impact your application's availability."
url: "https://hashnode.com/posts/postgresql-concurrent-indexes-in-rails-avoiding-downtime-in-production/6a2fd3d893fd5e9c7afbdf9c"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [PostgreSQL Concurrent Indexes in Rails: Avoiding Downtime in Production](https://railswithyashika.hashnode.dev/postgresql-concurrent-indexes-in-rails-avoiding-downtime-in-production?utm_source=hashnode&utm_medium=feed)

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.

Jun 15 · 4 min read · railswithyashika.hashnode.dev  
Updated Jul 7  
Read the article

-   [#indexing](https://hashnode.com/tag/indexing)
-   [#concurrent](https://hashnode.com/tag/concurrent)
-   [#db](https://hashnode.com/tag/db)
-   [#performance](https://hashnode.com/tag/performance)
-   [#concurrent-indexes](https://hashnode.com/tag/concurrent-indexes)
-   [#rails](https://hashnode.com/tag/rails)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#production](https://hashnode.com/tag/production)
-   [#downtime](https://hashnode.com/tag/downtime)
-   [#software-engineering](https://hashnode.com/tag/software-engineering)
-   [#web-development](https://hashnode.com/tag/web-development)
-   [#backend-development](https://hashnode.com/tag/backend-development)
-   [#sql](https://hashnode.com/tag/sql)
-   [#activerecord](https://hashnode.com/tag/activerecord)
-   [#database-optimization](https://hashnode.com/tag/database-optimization)

## Written by

[Yashika Vijayvargiya](https://hashnode.com/@railswithyashika)

@railswithyashika · Pune, India

  
[View profile](https://hashnode.com/@railswithyashika)

Senior Ruby on Rails Engineer | React | System Design | Sharing Real-World Engineering Lessons

Senior Ruby on Rails Engineer sharing practical insights on Rails, React, system design, performance optimization,. My goal is to simplify complex concepts through real-world examples and hands-on experiences.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
