article 2026-10-09 13 min 2099 views

Connection pool sizing for Postgres + async SQLAlchemy

A practical walkthrough of databases with numbers and failure modes.

postgresqlsqlalchemy

Setup

You need a reproducible load profile before arguing about frameworks. Same payload, same concurrency, same machine.

Method

  1. Warm the process for 30 seconds.
  2. Run fixed concurrency (not “as fast as possible”).
  3. Record p50/p95/p99 and error rate separately.
# example shape — replace with your harness
hey -n 20000 -c 64 https://fast-api.online/api/v1/status

Results shape

Metric Low concurrency High concurrency
RPS stable collapses when pools exhaust
p99 dominated by GC/IO dominated by queueing

Takeaways for Connection pool sizing for Postgres + async SQLAlchemy

  • Fix the bottleneck you measured, not the blog post you liked.
  • Pool size and worker count interact; change one variable at a time.
  • Publish the command line with the chart or the chart is decoration.

Related