~/talk

Time travel with Neon

Talkat PostgreSQL Conference Europe 2024 · 2024-10-22..10-25· [databases]
links:none on file
slides:none on file

Neon replaces local disks with a networked storage system that keeps every page version and reconstructs pages on demand from WAL-like reshuffled delta files and S3, enabling page-level recovery and instant branching. A demo shows a serverless Postgres instance starting in about one second to run queries at arbitrary LSNs (time travel works), backed by safekeepers for recent WAL and page servers for reads. Implementation notes: LSM-style compaction, local SSD cache, shared_buffers set to 128MB, current storage amplification ~2–3x, largest deployments ~1–5 TB.

AI-written summary · about

  1. 0:00Introduction to Neon
  2. 1:09What is Neon and its storage system
  3. 3:14Traditional PostgreSQL setup vs Neon
  4. 6:45Neon storage architecture overview
  5. 9:59Time travel and page reconstruction
  6. 12:04Point-in-time recovery with time travel
  7. 16:17Live demo of Neon time travel
  8. 22:42Branching in Neon
  9. 24:29Q&A on hot pages and edge cases
  10. 26:17Managing branches at scale
  11. 28:22Scaling large databases
  12. 29:50Open source and on-premises options
  13. 31:16Caching and performance optimizations
  14. 32:39Optimizations and user data changes
  15. 33:21On-the-fly time travel limitations
  16. 34:04PostgreSQL version upgrades
  17. 35:29Storage size and pricing model
  18. 37:57Pricing model challenges
  19. 38:18Image compression and patches
  20. 39:23Retention policies and branching
  21. 39:45Streaming replication with Neon
  22. 40:48PostgreSQL backups with Neon
  23. 41:52Shared buffers and caching
  24. 42:36PostgreSQL extensions support
  25. 43:18PostgreSQL version releases
  26. 44:01Fast VM spin-up for branches
~/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.