Date: 2023-10-03
Time: 14:00–14:50
Room: The Forum
Level: Beginner
Feedback: Leave feedback
You're a DBA or Developer and you've been hearing more and more about Postgres and maybe even used it a few times, but aren't sure where to get started to learn more. In this session, I'll teach you the basics of how Postgres works using a copy of the Stack Overflow database ported to Postgres. You'll learn how the Postgres engine stores data in tables and indexes, how it builds execution plans and how to understand those plans using EXPLAIN, as well as how memory, caching (or the lack thereof), and indexes can affect those plans, all using simple printouts representing our tables. This session is perfect for folks who want to enhance their understanding of Postgres internals and how to apply that knowledge when working with queries. Join us and take your PostgreSQL query performance to the next level!