3 videos · 3 events · 2023–2025 · 1h 36m of video
0:31:13
DjangoCon Europe 2025 · June 13, 2025
Karen Jex traces a database operation from a Django request to PostgreSQL and back. She explains how PostgreSQL parses, rewrites, plans, and executes SQL; how sequential scans, indexes, bitmap scans, joins, sorting, and 8 KB pages fit together; and how inserts, deletes, and updates are…
0:30:38
DjangoCon Europe 2024 · July 11, 2024
Karen Jex explains that although developers are increasingly expected to manage databases, they do not need to become expert DBAs. They should understand how their data fits together, write and inspect SQL, recognize the basics of backups and recovery, security, monitoring, performance, and maintenance, and…
0:34:11
DjangoCon Europe 2023 · June 8, 2023
PostgreSQL works well with its defaults, but production systems often benefit from tuning a small number of configuration parameters rather than trying to understand all of them. Karen Jex explains how settings can be applied at cluster, database, role, session, or transaction scope, and how…