Beyond Agents: Why You Should Still Care About Database Internals
summary
Patrick Stählin from Aiven explains why PostgreSQL internals still matter despite automation and agent-driven workflows. The talk covers PostgreSQL storage and design decisions that affect performance under high load, real-world large-scale operational failure stories, and patterns to understand to avoid scalability and disk behavior issues.
AI-written summary · about
chapters (11)
- 0:00Introduction
- 1:47Database lifecycle challenges
- 3:32PostgreSQL MVCC basics
- 8:12PostgreSQL storage internals
- 11:22Write-ahead log impact
- 14:40Real-world performance pitfalls
- 17:50Transaction visibility and snapshots
- 20:57Optimizing long-running transactions
- 23:04Vacuuming and cleanup
- 26:40Key takeaways
- 29:07Q&A
related talks
46mPostgreSQL Analytics: It's a Trap!
47mWhat If We Opened PostgreSQL's Hood?
39mDeep dive into PostgreSQL internal statistics
49mHow Databases Work - For Developers, Accidental DBA's and Managers
35mPostgres in Artificial Intelligence
21mDriving the Future of PostgreSQL Adoption
04mRoad to Percona Live 2022 - Andreas Scherbaum - PostgreSQL Talk
01h 00mPostgres at the Heart of Your Data Center