Hi wrt keeping the database size and performance good is the

Question

Hi wrt keeping the database size and performance good is there a way to set some sort of retention rate policy on the database that maintains the flows flowruns etc

Sander · Answer

I m referring to a Postgres database for 2 0

Anna Geller · Answer

you may use e g <https github com citusdata pg cron|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

Sander · Answer

I m running my own Postgres and gui There are no on delete cascade foreign keys

Sander · Answer

Actually Let me check

Sander · Answer

Looks fine to me actually Some depend rows are deleted and some are set to null No doubt there are some bugs here and there but generally structure looks ok Referring to bugs as at some point I ran into the issue where I couldn t reset the database due to foreign key constraints slightly smiling face

Anna Geller · Answer

yup FK constraints is exactly what I meant if not doing it carefully you may cause issues

Sander · Answer

I guess it somewhere on the roadmap to provide some cleanup scripts to allow proper cleanup of the database

Sander · Answer

No need now but wondering

Anna Geller · Answer

I can open an issue if you want

Anna Geller · Answer

< Marvin> open Consider adding DB cleanup scripts to save space in Postgres

Marvin · Answer