Postgres What They Really Use
summary
Heroku reports running over a billion transactions a day and breaks out actual usage: 17% of production databases enable extensions (about 22% of those use hstore), 22.9% show bloat >100MB (8.7% >1GB, 1.5% >10GB), many apps carry large unused indexes (23% have an index >1,000 rows used <5%), early adoption of foreign data wrappers and plv8 (JavaScript-in-db functions returning JSON) appears in production, and tooling like postgres.app, pg_extras and data clips exist and are in active use.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 4:42Postgres developer practices
- 12:26Index usage stats
- 18:30Extensions and their adoption challenges
- 22:01New user pain points
- 27:53Why ORMs slow down advanced features
- 31:42Q&A
