Breakout Session
summary
PostgreSQL 9.5 adds a concrete UPSERT: an INSERT ... ON CONFLICT clause that either inserts or updates without racey subtransaction hacks and with better performance than legacy patterns, using an excluded pseudo-table for proposed rows and an inferred Arbiter index to decide conflict targets. It supports DO UPDATE and DO NOTHING (the latter for exclusion constraints and foreign data wrappers), works with partial and expression indexes, RETURNING, EXPLAIN output, and real-world OLTP and data‑integration use cases — implemented, tested, and deployed.
AI-written summary · about
chapters (26)
- 0:00Introduction
- 0:46What is absurd
- 2:08Fundamental observed property
- 6:09Excluded table
- 8:27Inference specification
- 13:35Merge
- 15:10Mirage
- 17:17Stack Overflow
- 18:06Summary
- 19:37MongoDB Bugs
- 21:08MVCC
- 22:22New Use Cases
- 22:41Data Integration
- 24:42Complex Data Landscape
- 25:53Good Primitives
- 26:36An accidental distributed system
- 27:04disparate retail systems
- 27:57supplier exclusivity
- 29:04sync process
- 31:00advanced capabilities
- 32:27practical example
- 36:12safety first
- 37:12flexibility
- 40:32inference
- 43:04advanced features
- 48:58further questions
related talks
46mThe MERGE Command
51mExploring new enhancements and improvements Fujitsu has delivered to
28mPostgreSQL 9.4 and Beyond
49mConcurrency Deep-Dive
52mA look at the Elephants Trunk - PostgreSQL 15
24mPostgreSQL Design Patterns
34mBeyond CRUD: the PostgreSQL techniques your Rails app is missing.
30mLesser known features of PostgreSQL