Skip to content
Chaos Lab

Challenge 37 · starter · Orders database

Database bottleneck

Order history pages hit one PostgreSQL primary with 8 cores, 800 page views a second. At 10 seconds v8 ships "recent orders": one more query per page.

From 15 to 60 seconds, answer at least 99.5% of pages with p99 at or under 200 ms, without spending more on the database (cost 1×).

ready00:00 / 01:00Success · 10 s–p99 · 10 s–

Goal · measured 00:15–01:00

0 changes · par 1
  • Pages answered ≥ 99.5%not measured yet
  • p99 latency ≤ 200 msnot measured yet
  • Database cost ≤ 1× costnot measured yet

This is a simulation. Its numbers come from a model of a typical system, not from measuring real servers. The same link and seed always give the same run. How the Chaos Lab works.