you may use e.g.
pg_cron or something like that to periodically run some DBA tasks such as purging old logs, but be careful about which data you delete, e.g. purging logs should be fine, but purging flow runs you need to be careful to not break other tables that reference that flow run ID
btw I thought you are on Cloud 2.0? if so, you don't have to worry at all about DBA tasks and retention policies