What Microsoft is Building for Postgres – 2025 in Review | Claire Giordano | PGConf NYC 2025

In the slides from this Microsoft-sponsored keynote at PGConf NYC 2025, you’ll get a birds-eye overview of the Postgres work happening at Microsoft in 2025. This keynote will share 4 things with you: (1) our Postgres open-source work, including some of the significant contributions the Microsoft team has made to Postgres 18; (2) our investments in Azure Database for PostgreSQL to improve enterprise security, performance, and availability; (3) new AI features for developers in the Azure cloud and the new VS Code extension for PostgreSQL, and (4) our active participation in the Postgres community—which among other things includes sponsoring Postgres conferences like PGConf NYC and organizing POSETTE: An Event for Postgres.

Transcript

1. What Microsoft is Building for Postgres —2025 in Review Claire Giordano Head of Postgres Community Initiatives at Microsoft
2. aka.ms/blog-pg-at-microsoft
3. Open source Developers Cloud Community
4. Open Source
5. aka.ms/blog-pg-at-microsoft
6. PostgreSQL 18 Released!
7. Contributing to the upstream Postgres project is necessary— Contributions that benefit upstream open- source project ALSO benefit our downstream Azure customers Downstream service: Upstream Postgres open-source project Upstream project Downstream service
8. Upstream project Downstream service Downstream service: Upstream Postgres open-source project What might not be obvious— Learnings from Azure customers also benefit the Postgres project
9. People at Microsoft who work on PostgreSQL Postgres Committers employed by Microsoft (out of 31 total) Postgres Open Source contributors employed by Microsoft
10. Microsoft contributions to PostgreSQL 18 Postgres 18 commits (out of 3,315) credited to Microsoft authors or co-authors of Postgres 18 commit reviews done by Microsoft contributors (948/5,313) As of Postgres 18 GA on 25 Sep 2025
11. 537 Postgres 18 commits authored/co-authored by Microsoft engineers Just a few of PG 18 Contributions from Microsoft… Asynchronous I/O Streaming reads in vacuum & bitmap heap OAuth infrastructure for authentication Amortize aggressive vacuum costs Fast database cloning Reduce planning time for partitioned tables Speed up hash GROUP BY & Hash Joins
12. Sep 30 | 11:30am AIO in PG 18 and beyond Andres Freund SPEAKER You should go to Andres’s talk at PGConf NYC (or at PGConf EU later in October)
13. Seeing the Async I/O subsystem land in Postgres 18 is really cool. It's a big step forward—a foundation for a whole new I/O architecture that opens the door to modern and efficient I/O technologies. —Thomas Munro, PostgreSQL hacker @ Microsoft About Asynchronous I/O in Postgres 18 It's been awesome to be able to help Andres Freund with this project (I worked on portability, vectored I/O, streaming APIs, and a few other bits and pieces) as finding a path to land these changes incrementally across releases has been a challenge. And we're not done yet. The interesting work continues.”
14. Recent Talking Postgres podcast episode: Ep31: What went wrong (& what went right) with AIO TalkingPostgres.com
15. Talks by our Keynote: What Microsoft is Building for Postgres – 2025 in Review Sep 29 | 9:40am Claire Giordano Postgres on Azure - accelerating performance, AI, & developer workflows Sep 29 | 1:30pm Divya Bhargov & Maxim Lukiyanov Ten Postgres Hacker Journeys—and what they teach us Sep 29 | 4:00 pm Claire Giordano AIO in PG 18 and beyond Sep 30 | 11:30 am Andres Freund Improved Freezing in Postgres Vacuum: From Idea to Commit Oct 1 | 11:00 am Melanie Plageman
16. Cloud
17. Announcing… Postgres 18 Preview is now available in Azure Database for PostgreSQL
18. aka.ms/pg18 PostgreSQL 18 Preview on Azure Database for PostgreSQL – Flexible Server
19. Developers Enterprise Everybody loves Postgres Migrating and deploying mission critical apps Writing the first line of code
20. Azure Database for PostgreSQL is enterprise-ready today Entra ID Private Endpoints Virtual Networks Data Encryption Azure Defender Availability Zones Geo DR Performance Azure Policy Azure Advisor
21. APR 2025 aka.ms/blog-pg-at-microsoft Postgres Workstreams at Microsoft
22. January DiskANN - Preview hll, topn, tdigest extension support Quickstart guide for .NET SDK Azure Database for PostgreSQL 2025 In Review
23. February Enhanced connection & cpu monitoring Elastic Clusters in more regions Azure Advisor Performance Recommendations 'pg_signal_autovacuum_worker' role Azure Database for PostgreSQL 2025 In Review
24. March Fabric Mirroring – Preview Azure Data Factory Entra support Versionless CMK – Preview New region: New Zealand North Azure Database for PostgreSQL 2025 In Review
25. April Azure Database for PostgreSQL On-Demand backups – GA MCP Server – Public Preview Updated Terraform module Tunable server params for performance 2025 In Review
26. May Azure Database for PostgreSQL SSDV2 with HA – Preview PG17 Major Version Upgrade –Preview VS Code extension for PostgreSQL Versionless CMK - GA 2025 In Review
27. June Azure Database for PostgreSQL Online migration service – GA PG17 Major Version Upgrade – GA New Region:  Indonesia Central New Ansible collection released 2025 In Review
28. July Azure Database for PostgreSQL Upsert & Script activity in ADF – GA New Regions:  Malaysia West, Chile Central Cascading Read Replicas – Preview Power BI Entra authentication – GA 2025 In Review
29. August Azure Database for PostgreSQL New performance recommendations – GA Entra-group login credentials – Preview New Region:  Austria East LangChain & LangGraph Connector 2025 In Review
30. September Azure Database for PostgreSQL PG 18 – Preview Azure Confidential Computing - GA Azure Migrate PG Discovery – Preview Entra ID token refresh code samples 2025 In Review
31. aka.ms/azure-postgres-blog
32. US Gov Texas South Central US Brazil South Brazil Southeast Australia East Australia Southeast Australia Central Australia Central 2 US Gov Arizona West US West US 2 West US 3 West Central US Central US North Central US Canada Central Canada East South Africa North South Africa West UAE North Qatar Central UAE Central Israel Central India South India Central Jio India Central Jio India West Southeast Asia China North 2 China North 3 Korea Central Korea South Japan East Japan West East Asia China East 2 China East 3 France Central France South Spain Central Norway East Norway West Sweden Central West Europe Poland Central Germany North Germany West Central Austria East Switzerland North Switzerland West Italy North Industry-leading global reach of Azure Available Coming soon Azure regions available New Zealand North Chile central East US East US 2 Indonesia Central Malaysia West Mexico Central US Gov Virginia India South Central Taiwan North Belgium Central Denmark East North Europe UK South UK West
33. Follow Azure Database for aka.ms/azure-pg-linkedin PostgreSQL on
34. AI in Azure
35. Bringing generative AI features into Azure Database for PostgreSQL DiskANN Semantic Operators Graph-based RAG & Apache AGE LangChain & LangGraph MCP Server
36. DiskANN Vector Index Highly performant, scalable, and accurate index for vectors Reduced memory footprint with quantization and storing SSD Unique to Azure CREATE INDEX idx ON articles USING diskann (vector vector_cosine_ops); Huge cost savings at scale due to reduced memory footprint. Quantization improves speed and accuracy of vector search
37. Semantic Operators Preview generate() Preview is_true() Preview extract() Preview rank() Unique to Azure
38. Watch POSETTE talk about: Building Applications with Graph-Based RAG on PostgreSQL aka.ms/posette-abe-omorogbe-2025
39. Extension for Visual Studio Code for PostgreSQL
40. 211k+ developer installs “This is so cool… Having this kind of support in VS Code is nice to see.” The Copilot integrations look sweet, as does the schema view.” “Very nice and long awaited.” “Oh woah this looks great.” “I like that I can run this remotely with the VS Code SSH extension.” “Thank you, this is great.” “Nice that they’ve got it working so well with Copilot.” “VS Code… could be ‘the standard way to view a database in development’.”
41. Create a local PostgreSQL instance in Docker with a few clicks. Features in new VS Code extension for PostgreSQL Use connection profiles or strings to connect to any PostgreSQL database. Auth into your database using Entra ID. Explore tables, columns, & relationships in an interactive diagram Use the psql CLI with your connected databases Automatically save, view, edit, & re-run past queries. Then export as CSV, JSON, or Excel Write and run SQL with database aware IntelliSense in VS Code @psql in GitHub Copilot Ask Mode to chat with your connected databases Use GitHub Copilot Agent Mode to generate SQL, create tables, design schema, & more
42. Works with *ANY* PostgreSQL database
43. Give the new VS Code extension a try! aka.ms/pgsql-vscode
44. Watch POSETTE talk about: Visual Studio Code extension for PostgreSQL aka.ms/posette-matt-mcfarland-2025
45. Postgres Community
46. Sponsor & help organize Postgres conferences in 2025 P2D2 PGConf EU 2025 PG Down Under 2025
47. aka.ms/posette-playlist
48. PosetteConf.com/subscribe SAVE THE DATE
49. TalkingPostgres.com
50. Meet our Postgres team at
51. socks socks socks socks
52. Get your FREE socks @ Microsoft booth on some of our Postgres work
53. November 18-21, San Francisco Moscone Center
54. Thank you