One hot row

Store 09
SQLUsers3,000 req/sPostgres2 vCPU · 2 GB
SQLUsers3,000 req/sPostgres2 vCPU · 2 GB

Fix the board. Turn every goal green.

Traffic
3,000 req/s · writes only
Limit
Postgres answers about 5,000 writes/s
Bill
  • Postgres8 USD/mo
8 of 100 USD/mo

Goals

Not tested yet

99 of 100 requests finish faster than this.How busy the busiest CPU is. Keep room for spikes.What the servers and services cost each month.

All 3,000 writes/s increment one logical counter. One row makes every update wait in line. Keep the same write rate. Keep p99 below 100 ms and CPU below 80 percent.

0:00. Writes wait for one locked row. Graph: the wait queue on that row grows, and p99 passes 100 ms.

Parts you can add: Postgres. At most 16 parts. Budget: 100 USD/mo.

Tap a part to add it, or drag it onto a trace.Click a part to add it, or drag it onto a trace.