High Performance PostgreSQL for Rails

Working with PgBouncer

The Active Record connection pool helps you efficiently manage connections and is built-in to Ruby on Rails. By default, you’re using it, and it’s very helpful. However, connections that are made directly between the application and the database server do have an upper bound. Even before hitting the upper bound, performance may degrade severely.

When you need to add more capacity, how can you do that? Don’t worry, you’ve got options.

Dedicated connection pooling software exists to help you do that. This is extra software you can add to your stack. While a connection pooler brings additional operational complexity, it offers several benefits.

One of the biggest benefits is being able to expand beyond the physical limit ...