Making Postgres Central in Your Data Center
summary
Claims Postgres can be the central data broker because of concrete features not buzzwords: PostGIS and jsonb for non‑relational workloads, specialized indexes like GIN/GIST/BRIN and a JIT compiler for analytics, 100+ foreign data wrappers to federate sources, and multiple PLs plus transactional schema changes so DDL is atomic. The roadmap is specific: parallel FDW scans in Postgres 14 enable read‑only sharding; read‑write sharding and cross‑shard prepared commits are worked on but not yet broadly benchmarked.
AI-written summary · about
chapters (28)
- 0:00Intro
- 1:17Outline
- 2:27Object-Relational (Extensibility)
- 5:20The System Catalog Entry for INTEGER
- 5:54The System Catalog Entry for ISBN
- 7:10Not Just Data Types, Languages
- 7:40Available Languages
- 8:50Specialized Indexing Methods
- 9:41Index Types Are Defined in the System Catalogs Too
- 10:27Operators Have Similar Flexibility
- 11:27Other Extensibility
- 11:43Externally Developed Plug-Ins
- 13:01Offshoots of Postgres
- 15:47Plug-In Is Not a Bad Word
- 17:15Extensions and Built-In Facilities Behave the Same
- 22:22Why NoSQL. Exists
- 24:57When Should NoSQL. Be Used?
- 26:38The Best of Both Worlds: Postgres
- 27:17Schema-Less Data: JSON
- 28:15Easy Relational Schema Changes
- 29:27Data Analytics
- 32:07Read-Only Replicas for Analytics
- 33:54Foreign Data Wrappers to Interfaces
- 34:14Foreign Data Wrapper Example
- 35:25Read and Read/Write Data Sources
- 35:47Postgres Centrality
- 36:32Postgres's Central Role
- 37:48Conclusion
related talks
01h 00mPostgres at the Core of Your Data Center
56mBreakout Session
01h 00mPostgres at the Heart of Your Data Center
48mData Horizons With Postgres
15mBuilding for the Future and Betting Big on Postgres
43mWhy Postgres
13mBuilding reliable infrastructure with Postgres
51mHow Postgres is Different (read BETTER than) your database