All the Postgres Things
summary
Microsoft-contributed code totals 412 commits in Postgres 17 including the readstream IO combining that reduces small 8K reads to fewer larger IOs and WAL improvements that merge vacuum and freeze entries to shrink WAL size. Cloud features include elastic clusters (Citus) with a two-node PGbench throughput of 123k at ~2 ms dropping to 205k at ~1.2 ms on four nodes. Vector search adds DISN for ~4x memory/cost savings and a published solution accelerator shows recall rising from 40% to 70% using semantic ranking plus graph RAG.
AI-written summary · about
chapters (9)
- 0:00Introduction to Postgres
- 2:35Postgres 17 community contributions
- 4:45Postgres 18 upcoming features
- 5:30Azure Database for Postgres updates
- 6:17Elastic clusters feature demo
- 9:57AI vector search with DiskANN
- 11:22Legal research copilot demo
- 14:57Advanced RAG techniques summary
- 15:20Closing and survey
related talks
24mAll The Postgres Things at Microsoft, POSETTE edition
42mPushing Postgres Forward: From Open Source Contributions to Intelligent T
22mKEYNOTE: Driving Postgres forward at Microsoft
21mWhat Microsoft is Building for Postgres in 2025
56mPerformance Improvements in PostgreSQL9 2
25mWhat’s New with Azure Database for PostgreSQL- Flexible Server
34mPostgres 10, Performance, and You
51mScaling Postgres to the next level at OpenAI