PostgreSQL 9.4 and Beyond
summary
PostgreSQL 9.4 introduces jsonb + GIN for binary JSON with much smaller indexes and faster searches, materialized views with CONCURRENT REFRESH to avoid exclusive locks, logical decoding to emit row-level inserts/updates/deletes from the replication stream, SQL-level configuration via ALTER SYSTEM, on-demand background workers and dynamic shared memory for parallel work. The release touches ~3,000 files with ~62,000 insertions and ~15,000 deletions; 9.4.1 ships in February. Upcoming 9.5 prototypes BRIN (block range) indexes and INSERT ... ON CONFLICT (upsert).
AI-written summary · about
chapters (19)
- 0:00Start
- 0:59Satoshi Nagayasu
- 2:11What I'm doing on PostgreSQL
- 3:25Hacking Hardware
- 5:029.4 Overview - Status
- 5:319.4 Overview - Statistics
- 5:599.4 Overview - Changes
- 6:25Categories of Enhancements
- 6:50NoSQL - JSONB
- 7:48NoSQL - GIN Index
- 8:53Analytics - Aggregation
- 10:08Analytics - Materialized Views
- 12:02pg_recvlogical (contrib)
- 13:14Dynamic Background Workers
- 14:07Dynamic Shared Memory
- 14:45pl/pgsql stacktrace
- 15:43BRIN Index
- 18:33Wrap-up
- 19:47Resources
