PostgreSQL for the SQL Server DBA: Architecture and Internals - Part 2

PostgreSQL’s internals might seem unfamiliar at first, but they share many concepts with SQL Server. In this session, we’ll dive into how PostgreSQL plans and executes queries, manages concurrency, and optimizes performance through indexing, statistics, and cost-based execution plans. We’ll explore cardinality estimation, locking and blocking behavior, and essential tools for monitoring and tuning. With practical comparisons to SQL Server’s internals, this session equips you with the insights needed to troubleshoot, tune, and maintain PostgreSQL databases with confidence.

Map SQL Server architectural concepts to PostgreSQL core processes, memory, and storage Understand how PostgreSQL manages connections, transactions, and background processes Learn how extensions and configuration settings are used to tune PostgreSQL for real workloads