search

dbos-inc / dbos-transact-py

Ultra-Lightweight Durable Execution in Python
https://docs.dbos.dev
MIT License
244 stars 7 forks source link

limit workeflow_inputs table growth? #138

Closed boltomli closed 15 hours ago

boltomli commented 1 week ago

It may be part of DBA but I'd like to know if dbos already supports workflow_inputs regular cleanup and flush. Or is there a switch to turn off the store explicitly?

qianl15 commented 17 hours ago

Workflow tables garbage collection isn't built-in, but it's easy to set up--regularly delete WITH CASCADE from the workflow_status table all non-PENDING workflows older than some retention period. Deleting a workflow from the workflow_status table automatically cascades to all system database tables.

In our hosted solution, DBOS Cloud, this is done automatically.