Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Scaling PostgreSQL Beyond Query Optimization

Confreaks via YouTube

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

Reviews

Start your review of Scaling PostgreSQL Beyond Query Optimization

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.