Postgres Demystified
summary
Postgres claims practical features not buzzwords: arrays, hstore and native JSON for schemaless fields used in production, range types plus an exclusion constraint that prevents double‑booking seats, pv8 letting JavaScript run inside the DB, and foreign data wrappers that query Redis Oracle MySQL and even Twitter. Operational tools include pg_stat_statements and a visualizer on GitHub, guidance to create index concurrently, targets like a 99% cache hit rate, and HyperLogLog at ~180 bytes with ~1% error for uniques.
AI-written summary · about
chapters (22)
- 0:00Introduction
- 0:40PSAs
- 1:36Agenda
- 1:55Brief History
- 2:26Postgres Origins
- 3:01MVCC
- 3:27Why Postgres
- 3:49TLDR
- 4:02Postgres
- 4:52Data Types
- 7:30Postgres Extensions
- 8:23Hstore
- 9:19JSON
- 10:39Sequential Scans
- 11:17Index Types
- 12:33Explain
- 14:40Index Tips
- 15:50Postgres Performance
- 18:03Postgres Stat Statements
- 20:11Query
- 25:03HyperLog
- 26:16Extras
related talks
43mWhy Postgres
51mHow Postgres is Different (read BETTER than) your database
48mData Horizons With Postgres
33mPostgres, the Best Tool You're Already Using
53mThe NoSQL Store everyone ignores: PostgreSQL
33mSchemaless SQL The Best of Both Worlds
49mSELECT 'amazing features' FROM "postgresql"
34mSimple and Awesome Database Tricks