What's New in PostgresSQL 9.3
summary
PostgreSQL 9.3 ships (released Sept 9) with about 227,000 lines added and ~100,000 removed and delivers concrete changes: SQL-level lateral queries and richer range-type indexing (SP-GiST), indexed regular expressions via trigram, full JSON accessors plus json_agg, parallel pg_dump/pg_restore, COPY FROM/TO PROGRAM and COPY FREEZE for fast loads, background worker API, and optional page checksums (storage-level corruption detection, enabled at initdb). Cluster-to-cluster access uses postgres_fdw with pushdown and writable foreign tables; materialized views exist but refresh takes an exclusive lock.
AI-written summary · about
chapters (16)
- 0:00Introduction and background
- 1:49Release resources
- 3:20Development process
- 5:51Post-release and categorization
- 9:30Lateral SQL queries
- 14:11Indexing enhancements
- 17:52JSON and data type support
- 22:08View improvements
- 27:44Logging and error reporting
- 29:14Bulk load and FDW updates
- 36:49Replication changes
- 38:27Parallel backup
- 40:55Infrastructure and OS
- 43:30Configuration management
- 45:45Low-level features
- 50:39Event triggers and Q&A
