High Performance PostgreSQL for Rails

Lock Up on Your Way Out

In this chapter, you’ve seen challenges that arise at greater levels of concurrency, whether they be from using limited database connection resources, or lock behavior with concurrent writes and reads.

You learned that concurrent activity can be scaled to greater levels beyond what’s possible with physical connections by introducing connection pooling software. You explored connection pooling on the application level and using PgBouncer, configuring it for Rideshare. You saw how to integrate PgBouncer with a Ruby on Rails application to use the best features available while retaining as much client functionality as possible. To improve the resiliency of your system, you explored various timeout values that help limit the ...