discussion 2026-10-18 1166 views 1 votes

Share your RPS numbers for JSON CRUD

@piotr
Backend Engineer

Hit this in staging after bumping workers.

Error / symptom: Share your RPS numbers for JSON CRUD

Traceback (most recent call last):
  File "app/main.py", line 42, in endpoint
    await db.execute(stmt)
TimeoutError: connection pool exhausted

Env: Python 3.12, FastAPI 0.115, uvicorn workers=4, Postgres 16.
What am I missing in pool settings?

3 replies

@leo_cache
2026-10-18 12:54 UTC · 6 votes

nginx buffering? if upstream resets, look at proxy_read_timeout before blaming uvicorn.

@mei
2026-10-18 23:29 UTC · 1 votes

try pool_timeout=30 and lower pool_size to 5 per worker first.

@raul
2026-10-19 04:28 UTC · 9 votes

try pool_timeout=30 and lower pool_size to 5 per worker first.