Upcoming presentations
PostgreSQL Statistics Unleashed: Mastering Query Optimization Through Data-Driven Insights
Database Statistics in PostgreSQL: What the Query Planner Knows and How It Decides
Understanding Database Statistics in PostgreSQL
Database statistics are the secret weapon behind PostgreSQL's query optimizer, directly impacting query performance and overall database health. This session takes you beyond the basics to explore how PostgreSQL collects, maintains, and leverages statistics to make intelligent decisions about query execution.
Whether you're managing a handfu...
Past presentations
- Key architectural updates in va...
Deep Dive into PostgreSQL Vacuum Internals: Enhancements, Challenges, and Untold Stories
Deep Dive into PostgreSQL Vacuum Internals: Enhancements, Challenges, and Untold Stories
Vacuum is the unsung hero of PostgreSQL, ensuring database health, reclaiming storage, and maintaining query performance. However, its internal mechanisms, recent improvements, and peculiar corner cases often remain a mystery to many users and developers. This presentation will explore the intricate workings of PostgreSQL's vacuum process, shedding light on: