Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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