What’s it like to lead Postgres engineering at a cloud giant like Microsoft Azure? In this episode of Talking Postgres, host Claire Giordano chats with Affan Dar, VP of Engineering for Postgres at Microsoft. Affan’s team is behind the Azure Database for PostgreSQL managed service and also contributes extensively to the upstream Postgres open-source project. Affan walks us through his career journey—from his first job as an embedded systems engineer, to navigating the shift between engineering and management, to leading one of the largest Postgres engineering teams in the world. He shares the strategy behind Microsoft’s investments into Postgres, explores how massive cloud fleets are influencing the future of Postgres, and shares what keeps him up at night.

Links mentioned in this episode:

• Docs: Azure Database for PostgreSQL – Flexible Server
• GitHub repo for Durable Task Framework, the first open source project Affan worked on
• GitHub repo for pgvector open source extension to Postgres
• Docs: Elastic cluster feature in Azure Database for PostgreSQL – Flexible Server, based on Citus
• GitHub repo for Citus open source
• Blog post: Postgres horizontal scaling with elastic clusters on Azure Database for PostgreSQL, by Adam Wølk
• GitHub repo for DiskANN open source
• Docs: How to enable and use the DiskANN index for Azure Database for PostgreSQL – Flexible Server
• Blog post: Think of language models like ChatGPT as a “calculator for words” by Simon Willison
• Blog post: What’s new with Postgres at Microsoft (updated 2x/year typically)
• Video of Talk at Microsoft Ignite: Improving accuracy of GenAI apps with Azure Database for PostgreSQL by Maxim Lukiyanov (Microsoft), Jay Yang (UBS), & Orhun Oezbek (UBS)
• CFP: POSETTE: An Event for Postgres 2025 CFP open until Feb 9 2025
• Calendar invite: LIVE recording of Ep23 of Talking Postgres podcast to happen on Wed Jan 15, 2025 with guest Daniel Gustafsson