@elias
2026-11-14 01:35 UTC · 4 votes
idempotency key in Redis with SET NX EX 86400 is fine if you accept rare loss on failover.
Hit this in staging after bumping workers.
Error / symptom: BackgroundTasks vs arq for email send
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?
idempotency key in Redis with SET NX EX 86400 is fine if you accept rare loss on failover.
paste your sqlalchemy engine kwargs. pool_size and max_overflow matter more than worker count here.
also check you are not creating an Engine inside the request.
orjson helps CPU a bit; it will not save a saturated DB.
readiness should hit a cheap SELECT 1; liveness can stay process-only.
orjson helps CPU a bit; it will not save a saturated DB.