Maintaining Large Tables in PostgreSQL | POSETTE: An Event for Postgres 2026

From the creator

Understand the challenges that large tables create at scale in PostgreSQL. Sarat Balijepalli (Microsoft) focuses on these issues in his talk “Maintaining Large Tables in PostgreSQL” at POSETTE: An Event for Postgres 2026. Abstract: This talk focuses on the real problems large tables create at scale: autovacuum falling behind, bloat accumulating silently, planner misestimation, WAL explosions, and maintenance operations colliding with production traffic. Rather than treating these as isolated issues, we’ll examine them as symptoms of unsustainable data growth. Using PostgreSQL (with specific considerations for Azure Database for PostgreSQL), the session walks through practical strategies to sustain performance over time: per-table autovacuum tuning, bloat and statistics management, maintenance options, and observability guardrails. Finally, we’ll address the critical architectural questions: when is a large table no longer the right abstraction? We’ll compare options such as partitioning, hot/cold splits, rollup tables, sharding, and offloading analytical workloads. Sarat Balijepalli has 18+ years of experience working on Oracle and Postgres databases. Currently he is working as a Senior Engineering Manager leading the performance charter in Azure Postgres team. ► Video chapters: ⏩ 00:00 – Music & introduction ⏩ 01:58 – Autovacuum limits and table bloat ⏩ 03:16 – Cache inefficiency and I/O bottlenecks ⏩ 04:20 – Vacuum / freeze storms explained ⏩ 06:33 – WAL volume explosio

Published 2026-06-17 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.