PostgreSQL - the database-sister of Python
summary
Postgres claims practical strengths: streaming replication for private clouds, PL/Python for in‑database Python functions (untrusted only for superusers), and pgpool for read scaling; version history shows major performance gains since 8.1–8.4 (redesigned shared buffers, bitmap scans, autovacuum defaults). Notes concrete limits from the slides—table size ~32 TB, max row ~1.6 TB—and cites a deployed partitioned system at Skype on ~64 shards. A web‑publishing tool and numerous extensions are shown to work in production.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 11:07What is PostgreSQL
- 14:44PostgreSQL license
- 20:46Database commitment
- 24:21Community governance
- 27:14Performance improvements
- 32:13Open source matters
- 33:57Extensibility and Python
- 37:13Programming languages
- 41:11Data security and logging
- 43:20Scaling in the cloud
- 45:31Q&A
