Getting ready for PostgreSQL 9.1

on YouTube ↗21m

" summary

Overview of PostgreSQL 9.1 changes with concrete demos and a hands‑on install: live install of beta1/beta2 on laptops and Mac/Linux, implementation details of streaming replication with WAL sender/receiver and per‑transaction synchronous replication (including the blocking/timeout tradeoffs and network failure behavior), new features like writable CTEs, foreign tables and smarter partition pruning, plus notes on real deployments (OpenStreetMap migration, multi‑year 99.999 uptime examples) and sponsorship for declarative partitioning.

AI-written summary · about

" chapters (11)

1. 0:00Introduction
2. 2:32PostgreSQL usage
3. 4:43PostgreSQL 9.1 training
4. 7:33Why PostgreSQL
5. 10:05PostgreSQL ecosystem
6. 11:32PostgreSQL for business
7. 12:37PostgreSQL 9.1 features
8. 13:24Synchronous replication demo
9. 15:31Partitioning improvements Q&A
10. 18:08Replication and network failures
11. 20:24Closing remarks

" related talks

• 49mPostgreSQL Replication - The Most Exciting Technology on EarthEdward Snajder · Open Source Bridge 2013
• 54mBreakout SessionMagnus Hagander · PGConf Silicon Valley 2015
• 14mBuilding a better PostgreSQL togetherJonathan S. Katz · PGConf NYC 2022
• 48mWhat's New and Useful in PostgreSQL 9.5Ilya Kosmodemyanskiy · HighLoad++ 2015
• 02h 26mTutorialDenish Patel · PGConf Silicon Valley 2015
• 22mSecuring Postgres with streaming replicationJan Karremans · POSETTE: An Event for Postgres 2025
• 56mPerformance Improvements in PostgreSQL9 2Robert Haas · Postgres Open 2012
• 48mReplication RefreshSimon Riggs · PostgresOpen 2013