discussion 2026-11-12 2146 views 27 votes

Postgres vacuum after bulk delete

@leo_cache
Backend Engineer

Hit this in staging after bumping workers.

Error / symptom: Postgres vacuum after bulk delete

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

@sana
2026-11-12 14:47 UTC · 11 votes

also check you are not creating an Engine inside the request.

@cole
2026-11-12 17:55 UTC · 11 votes

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

@sana
2026-11-13 02:51 UTC · 4 votes

minimal repro with httpx ASGITransport would help.