Data Horizons With Postgres
summary
Argues that Postgres is a practical relational plus platform built for mixed workloads: native JSONB with GIN indexing, full‑text search via GIN/GIST, GIS via PostGIS, and pluggable columnar or sharding extensions. Claims extensibility dates to 1986, now enabled by extensions and over 100 foreign data wrappers to push queries to other stores. Notes practical scale limits (comfortable to tens of TB, not petabytes) and that integrated indexing and FDW pushdown make cross‑store analytics feasible without separate silos.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 3:50Data needs and challenges
- 10:09Data ingestion evolution
- 15:02Relational Plus concept
- 21:07Postgres design origins
- 27:44Unified data management
- 33:43Postgres as central platform
- 36:54Future of Postgres
- 41:27Balancing core and extensions
- 43:32Practical use cases
- 45:58In-memory and Postgres
- 47:04Q&A
