news 2026-11-10 5 min 470 views

Postgres prepared statements with asyncpg under load

Operational notes on databases: what to pin, what to smoke, what to ignore.

postgresqlasync

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 /docs and 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.

Related