Python, Prompt Engineering, Data Science — Build the Skills Employers Want Now
Most AI Pilots Fail to Scale. MIT Sloan Teaches You Why — and How to Fix It
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Learn advanced PostgreSQL scaling techniques that go beyond basic query optimization in this 25-minute conference talk from XORuby Atlanta 2025. Discover practical strategies for addressing database bottlenecks that emerge as Rails applications grow, focusing on often-overlooked areas that can significantly impact production performance. Explore memory tuning configurations, understand how autovacuum processes can fall behind and affect database performance, and master index and bloat maintenance strategies that keep your database running smoothly. Examine HOT (Heap-Only Tuple) updates and their role in improving database efficiency, while learning to identify warning signs that indicate your PostgreSQL instance needs attention. Gain actionable insights into database administration techniques that address the silent bottlenecks caused by default PostgreSQL behaviors that no longer scale with growing applications, moving beyond query-level optimizations to system-level improvements that deliver measurable production results.
Syllabus
XORuby Atlanta 2025 - Scaling PostgreSQL Beyond Query Optimization by Alex Yarotsky
Taught by
Confreaks