Breakout Session
summary
PostgreSQL 9.5 arrives with concrete changes: UPSERT (INSERT ON CONFLICT) provides atomic insert-or-update with an excluded virtual row, 2,700 files modified and ~250,000 insertions/deletions marks the code churn, BRIN indexes use 128-block ranges of 8KB to make huge tables queryable, GROUPING SETs and CUBE add rollup super-aggregates, ROW LEVEL SECURITY enforces per-row policies, import foreign schema automates FDW table creation, pg_rewind repoints old masters, and track_commit_timestamp and compressed WALs improve replication and diagnostics.
AI-written summary · about
chapters (14)
- 0:00Magnus Hagander
- 3:05Development schedule
- 4:17Current status
- 10:23SKIP LOCKED
- 13:26Row level security
- 19:50INSERT ... ON CONFLICT
- 26:31GROUPING SETS
- 31:27cluster_name
- 36:48ALTER SYSTEM RESET
- 40:17min and max wal size
- 43:12pg_stat_statements
- 44:37BRIN indexes
- 49:50Locking enhancements
- 51:50What's your biggest feature?
related talks
28mPostgreSQL 9.4 and Beyond
52mA look at the Elephants Trunk - PostgreSQL 15
55mWhat's New in PostgresSQL 9.3
48mWhat's New in PostgreSQL 9.4
56mPerformance Improvements in PostgreSQL9 2
51mExploring new enhancements and improvements Fujitsu has delivered to
21mGetting ready for PostgreSQL 9.1
52mSo you're new to Postgres...