~/talk

Stop scaling and start tuning

Talkat NDC Oslo 2026 · 2026-09-14..09-18· [databases, devops-and-delivery]
links:none on file
slides:none on file

Team uses App Insights and Zipkin traces to find an N+1 that makes a page go 7.8s, fixes it with eager loading or batching to ~390–415ms, then adds indexes on created_at and order_id to drop a 250ms query to ~47ms (5x). PGAdmin + EXPLAIN/plan reveals sequential scans. Sporadic 2+ second gaps trace to a tiny DB connection pool; limiting parallelism (p‑map / concurrency) and right‑sizing the pool removes the stalls.

AI-written summary · about

  1. 0:00Introduction and motivation
  2. 4:45Setting up monitoring and baselines
  3. 9:15Fixing N plus one query problems
  4. 24:56Optimizing large database queries
  5. 42:16Diagnosing connection pool delays
  6. 53:07Summary and key takeaways
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.