Home compute, Azure state: a practical multi-agent stack built around shared Postgres
MRobinsonTX · reddit · 2026-07-24
The author describes a cheap multi-agent setup where state lives in Azure and compute runs at home. The core of the system is a managed PostgreSQL Flexible Server plus Key Vault in Azure, while the orchestrator, agent runtime, memory service, and model router run on a local Mac mini / small PC.
Why this design works
- Failover is stateless: both the home machine and Azure standby point to the same Postgres database.
- Durable data stays in Azure: backups, PITR, and private networking are handled there.
- Local compute stays cheap: no need to pay for an idle cloud container all night.
- Fallback cost is known: Azure standby costs roughly $3–$4/day when activated.
Tradeoffs
- Postgres becomes the single point of failure, mitigated with PITR + HA tier.
- Failover is 90% automated, but still needs a manual approval step and takes 3–5 minutes.
- VPN/tunnel access adds about 10 ms per round trip, which the author says is negligible with connection pooling.
A key lesson: agent identity matters
Once multiple agents share one memory store, ambiguity appears fast: the planner, researcher, and other agents can bleed into each other’s context. The author now gives each agent a canonical identity, rewrites aliases on write, and emits events when an unknown peer shows up instead of silently sharding memory.
Cost control
- Routine tasks like classification, routing, and status updates run on cheaper models such as GPT-4o-mini.
- Frontier models such as Opus are reserved for security review and deep reasoning.
- A router with per-tier daily budgets prevents the orchestrator from drifting onto expensive models.
The overall message is pragmatic: Azure is the always-on spine, home hardware is the cheap muscle, and the biggest wins came from identity design and model-tier budgeting, not infrastructure polish.
More from coding & agent
- A Lovable-built internal tool replaced $200 a month in SaaS spend — PrajwalTomar_ · 2026-07-24
- A Claude plus video-model workflow can now turn one sentence into a 10-minute documentary — PrajwalTomar_ · 2026-07-24
- Founder asks which production agent failures really need catching before they bite — marcin_michalak · 2026-07-24
- Grok 4.5 picks WordPress REST API over HTML scraping in a cleaner agent workflow — gaganghotra_ · 2026-07-24
- MIT and Microsoft build a system that turns plain-language agent workflows into code — CurieuxExplorer · 2026-07-24
- How a deck-building agent stopped hallucinating by grounding every slide in trusted facts — Miserable_Donut8718 · 2026-07-24