~/talk

What's New in Postgres 18 & 19

Talkat DjangoCon US 2026 · 2026-08-24..08-28· [databases]
links:none on file
slides:none on file

Postgres 18/19 add concrete, usable features: UUID v7 with timestamp-ordering lets UUID primary keys be b-tree indexed; Virtual generated columns appear as computed non-stored fields the ORM can map; a built-in repack (online table rewriting) fixes bloat by copying live rows and swapping with minimal locks; async I/O claims 2–3× faster reads (benchmarks often show ~1.5×); index skip scanning lets multi-column indexes match on later columns; OAuth2 auth and SCRAM-256 replace MD5; early graph and object-storage extensions (pg_lake, pg_duckdb, Apache AGE) appear.

AI-written summary · about

  1. 0:00Introduction and welcome
  2. 1:15Postgres version overview
  3. 2:26UUID improvements in Postgres
  4. 4:42Virtual generated columns
  5. 6:07Returning old and new values on update
  6. 7:33Insert on conflict select
  7. 7:55Temporal constraints with b-tree gist
  8. 10:05Database constraints and window functions
  9. 11:15Async I/O and performance upgrades
  10. 12:21Index skip scanning for multi-column indexes
  11. 13:31Parallel index rebuilds
  12. 13:52Re-pack feature for table bloat
  13. 16:47Parallel vacuum workers and OAuth2
  14. 18:13Password hashing updates
  15. 18:54Query plan hints in Postgres 19
  16. 20:22Postgres extensions for analytics
  17. 21:53Graph queries in Postgres 19
  18. 23:45Summary and upgrade advice
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 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
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
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.