In this talk, we’ll explore how to write SQL the way Postgres “thinks.” You’ll learn practical tips to make your queries faster, more efficient, and easier to maintain. Topics include understanding the query planner, using indexes effectively, mastering joins and CTEs, leveraging window functions and advanced aggregation, and tapping into Postgres-specific features like JSONB, arrays, and UPSERT. By the end, you’ll have a toolkit of smart SQL strategies to solve common problems and write queries that scale with your data.