Why Postgres
summary
Postgres claims decades of maturity (over 30 years) while adding modern features: jsonb document support that is indexable, built‑in full text search good enough to replace Elasticsearch for many apps, and postgis geospatial features that rival commercial offerings. Tools include pg_stat_statements profiling and pg_partman auto‑partitioning (it precreates about four future partitions), and plpython plus pandas can produce a live recommendation engine in roughly two hours and ~20 lines of code. Use UUIDs over serial for primary keys; avoid the money type.
AI-written summary · about
chapters (26)
- 0:00Intro
- 1:101996
- 3:00Under the covers
- 3:37What is open source?
- 4:33Community structure
- 6:25Postgres bag of tricks
- 8:47Datatypes
- 9:16Money
- 9:54Serial UUID
- 10:40Shapes
- 11:29JSON
- 13:11Other key ones
- 15:39Indexing
- 16:15BTree
- 16:43GIN (Generalized Inverted Index)
- 17:16GIST (Generalized Search Tree)
- 19:20Full text search
- 20:31PostGIS
- 21:46Document storage
- 23:18A brief tour of extensions
- 23:37Pg_stat_statements
- 25:07Pg_partman
- 29:35Foreign Data Wrappers
- 30:21List of relations Name
- 33:14CTE Example
- 38:22The future
