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...

@ Postgres Conference: 2026
Anita Singh Angel Duenas Neyra
Essentials

    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:

    • Key architectural updates in va...

    @ Postgres Conference 2025

    Mar 21 2025

    Essentials