RubyFlow's platform is a resource for Ruby developers, offering insights into Ruby programming language, Ruby on Rails framework, and Ruby-related tools. Through articles, tutorials, and community discussions, RubyFlow offers insights into building web applications with Ruby and Rails. Developers can learn about Ruby gems, Rails conventions, and best practices in Ruby development to write clean and maintainable code.

Ruby Flow

Adding indexes to large PostgreSQL tables in production Rails apps can cause deployment failures due to lock timeouts. Standard index creation requires a SHARE lock that conflicts with write operations, and concurrent index creation can't run inside a transaction. The post presents a 'delayed migrations' pattern: a separate migration directory and custom Rake tasks that run index-creation migrations after deployment rather than during the release phase, with a longer lock timeout. This prevents a single slow index creation from blocking all deployments and allows retries without manual cleanup.

Rodrigo Rosenfeld Rosas

Other issues caused by concurrent index creation