~/talk

All The Postgres Things at Microsoft, POSETTE edition

Talkat POSETTE: An Event for Postgres 2024 · 2024-06-11..06-13· [databases]
slides:none on file

Microsoft reports 353 commits to Postgres in the last year with 27% made on behalf of others and contributions to Patroni, PgBouncer and pgcopydb; Postgres 17 gets Streaming I/O that reads up to 16 pages (128KB) at once, vacuum/WAL work cuts WAL by ~30% and pg_upgrade check runs up to 2x faster. Azure Database for PostgreSQL adds RDMA by default, Private Link and Entra ID support, Automatic Index Recommendations in preview, Azure AI extension GA and Azure Local AI single-digit ms embeddings; DiskANN retains recall where HNSW degrades.

AI-written summary · about

  1. 0:00Introduction
  2. 1:50POSETTE stands for
  3. 4:32Postgres 17 open source contributions
  4. 8:58Azure Database for PostgreSQL
  5. 11:02Investment pillars
  6. 16:02Index recommendations
  7. 17:40AI and Postgres
  8. 20:07Demo of local embeddings
  9. 21:05DiskANN vector indexing
  10. 22:19Our investments into Postgres
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.