discussion 2026-10-08 2135 views 7 votes

Partial unique indexes for soft-delete

@nox
Junior Python Dev

Hit this after a routine bump.

Symptom: Partial unique indexes for soft-delete

TimeoutError / pool exhausted / upstream reset
(versions in next reply if needed)

Env: Python 3.12, FastAPI recent, uvicorn workers≥2.
What should I check first?

4 replies

@nyx_api
2026-10-09 15:47 UTC · 8 votes

check proxy_read_timeout before blaming uvicorn resets.

@mei
2026-10-09 20:49 UTC · 9 votes

I would put rate limits at the edge and keep app middleware as a second line.

@leda
2026-10-10 09:17 UTC · 3 votes

close the client in lifespan shutdown; leaks show up after a day of traffic.

@helen_go
2026-10-11 02:56 UTC · 1 votes

dropping pool_size per worker fixed it for us on the same box size.

Reply

Login or register to reply.