Archiving Postgres Checkpointer

[Wildhammer]

How would you archive old conversations in postgres checkpointer for langgraph? I think it is fair requirement to be able to archive and purge conversations that are old in like a chatbot application. Otherwise the underlying postgres db will keep growing in size and all the old conversation data are hot and ready to be queried while there will never be accessed.

[hinthornw]

In langgraph platform we have the concept of TTLs (https://langchain-ai.github.io/langgraph/how-tos/ttl/configure_ttl/?h=ttl) - you could implement something similar on your own custom checkpointer by cleaning up old threads on a schedule

[Wildhammer]

I am using postgres saver from langchain, I haven't customized anything. I was looking at the schema and couldn't figure out how to implement TTL as I wasn't able to find any timestamp data. Can point me to the implementation details?

Thanks