Richard Yen

2 videos · 2 events · 2022–2023 · 1h 32m of video

Talks

How to Ride Elephants Safely: Working with PostgreSQL when your DBA is not around

DjangoCon US 2023 · December 14, 2023

Richard Yen explains the PostgreSQL skills Django developers may need when a DBA is unavailable: connecting to a server, starting and stopping the database safely, finding logs and configuration, inspecting sessions, managing access, and taking backups. He covers vacuuming, write-ahead logs, configuration such as `work_mem`,…

0:43:20

Explaining EXPLAIN: A dive into PostgreSQL's EXPLAIN plans

DjangoCon US 2022 · November 24, 2022

Richard Yen explains how PostgreSQL’s EXPLAIN and EXPLAIN ANALYZE reveal the plans and observed performance of queries, including scans, joins, costs, timing, row counts, and buffer activity. He shows how the cost-based planner uses statistics and configuration values to choose between sequential, index, bitmap, nested-loop,…

Spoken at

DjangoCon US 2022 2023