Hi — we're running SpiceDB (PostgreSQL datastore) and are looking into data retention options.
A few questions:
1. What mechanisms are available for controlling how long relationship data is retained?
2. Is there a recommended approach for bulk-deleting stale relationships for a specific object type or namespace without impacting read performance?
3. Does SpiceDB's
zed
CLI or the API expose anything specifically for retention workflows, or is it expected to be handled at the datastore layer?
We're particularly interested in whether there's a supported pattern for periodically expiring relationships tied to deleted application objects.
Thanks!