@nik
2026-11-18 02:43 UTC · 1 votes
thanks — dropping pool_size fixed p99. marking notes in the thread.
Hit this in staging after bumping workers.
Error / symptom: CORS preflight storm from SPA
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?
thanks — dropping pool_size fixed p99. marking notes in the thread.
orjson helps CPU a bit; it will not save a saturated DB.
orjson helps CPU a bit; it will not save a saturated DB.
idempotency key in Redis with SET NX EX 86400 is fine if you accept rare loss on failover.
also check you are not creating an Engine inside the request.
also check you are not creating an Engine inside the request.