Postgres prepared statements with asyncpg under load
Operational notes on databases: what to pin, what to smoke, what to ignore.
What changed
Postgres prepared statements with asyncpg under load is the short version. The parts that actually break production are below.
Practical notes
- Pin the dependency in lockfiles before rolling fleet-wide.
- Re-run your smoke against
/docsand one authenticated route. - Watch p99 for 15 minutes after deploy; mean latency lies.
from fastapi import FastAPI
app = FastAPI()
@app.get("/health")
def health():
return {"ok": True, "tag": "databases"}
Caveats
Do not treat changelog marketing as a migration guide. Diff the release against your current pin and only upgrade when the smoke list is green.