Beyond CRUD - The PostgreSQL Techniques Your Rails App Is Missing

Discover advanced PostgreSQL techniques for Rails applications in this 34-minute conference talk from RailsConf 2023. Explore real-world production outage scenarios and learn how to implement efficient PostgreSQL features to build scalable solutions. Gain insights into optimistic and pessimistic locking, with practical examples of their application in core customer features. Delve into the use of Postgres mutex for managing concurrent access to shared resources. Benefit from valuable lessons and experiences shared to help you avoid common operational pitfalls, enhance your application's reliability, and optimize query patterns.