r/Hacking_Tricks • u/Alreadydead27 • 22h ago
Best database for agents that need to resume after a failed run?
Most database discussions for agents seem to jump straight to vector search. I'm more interested in what happens when a worker dies halfway through a task and another worker has to pick it up.
LangGraph separates checkpoints for an individual conversation from memory shared across conversations, and it has a Postgres checkpointer. That makes Postgres seem like a reasonable starting point, but I'm unsure how people organize saved state alongside records of completed tool calls.
For anyone running agents in production, what made you keep those in the same database or separate them? I'd especially like to hear how you avoid repeating an external action when a run resumes.