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

For SQL Server professionals, learning PostgreSQL is an opportunity – not a hurdle. In this session, we’ll connect the dots between the two platforms by exploring PostgreSQL’s architecture, including is core processes, memory management, and storage layout. You’ll learn how PostgreSQL handles connections and manages transactions to ensure data integrity and reliability. We’ll also cover PostgreSQL background processes, along with the power of PostgreSQL’s extensions and server configuration settings that allow you to tailor performance and functionality to your needs. With practical comparisons to SQL Server’s architecture, this session will give you the confidence to design, configure, and manage PostgreSQL environments using the SQL Server knowledge you already have.

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