What's New in PostgreSQL 9.4
summary
PostgreSQL 9.4 adds concrete, usable features: jsonb stores parsed JSON but does not preserve key order and supports GIN/GIN‑trgm indexing for fast containment queries; ordered‑set and filtered aggregates (percentiles, mode, hypothetical aggregates) land; WAL gets a new logical change‑set extraction mode (increasing WAL size) and replication slots let standbys pin required WAL; GIN posting lists shrink pointers from ~90 to 21 bytes; refresh materialized view concurrently requires a unique index. 94 branch shows ~2,222 files changed, ~131,000 insertions and ~60,000 deletions.
AI-written summary · about
chapters (31)
- 0:00Intro
- 0:16Magnus Hagander
- 1:18Do you read...
- 2:27Development schedule
- 4:06Current status
- 6:53So what's really new
- 8:01Smaller aggregate changes
- 9:12FILTER aggregates
- 10:37Ordered-set aggregates
- 14:32Improved updatable views
- 18:32WITH ORDINALITY
- 19:32pl/pgsql stacktrace
- 20:19JSONB
- 23:21New features
- 23:41Dynamic background workers
- 24:41Dynamic shared memory
- 25:42MVCC catalog access
- 27:42Logical changeset extraction
- 29:31Replication slots
- 30:54MATERIALIZED VIEWS
- 32:00Move objects in tablespaces
- 33:10pg prewarm
- 35:21GIN Index fastscan
- 36:50ALTER SYSTEM SET
- 38:29New configuration parameters
- 40:31pg stat statements
- 41:31Time delayed standbys
- 42:41Backup improvements
- 43:22There's always more
- 43:54Tiny favorite?
- 44:37Just because we're Postgres
