A Guided Tour Through Postgres Internals with Elizabeth Garrett Christensen
summary
Sees exact commands and outcomes: psql backslash commands (\l, \c, \d+, \x) to list databases, switch, and describe tables; use of a public gist with runnable SQL; PostgreSQL 17 B‑tree improvements mentioned; how to read pg_stat_activity for blocking PIDs and connection counts; enabling pg_stat_statements slowest 10 queries to find long-running materialized view refreshes; queries to inspect locks, vacuum age, and cache hit ratio so troubleshooting yields actionable fixes rather than vague advice.
AI-written summary · about
chapters (8)
- 0:00Postgres internals intro
- 2:06Exploring Postgres with psql
- 5:00Navigating databases and tables
- 9:39Monitoring live activity
- 12:51Understanding locks and maintenance
- 15:16Query performance with pg_stat_statements
- 17:04Cache hit ratios and index usage
- 19:11Key takeaways and resources
related talks
34mSimple and Awesome Database Tricks
39mDeep dive into PostgreSQL internal statistics
45mSELECT 'amazing_features' FROM "postgresql"
49mSELECT 'amazing features' FROM "postgresql"
47mWhat If We Opened PostgreSQL's Hood?
56mPostgreSQL at low Level: stay curious!
47mBeginner's guide to PostgreSQL Hacking
29mPostgres Demystified