Maintenance Activities

[spammenotinoz]

Besides backups, via pg_dump are there any suggested maintenance activities for supabase?
What about cleaning up old chats and files?

To clean-up old chats for a specific user, would this be okay to run;
DELETE FROM chats
WHERE
user_id = 'substitute the uuid of the person'
AND created_at < NOW() - INTERVAL '2 weeks';

Or would that be a bad idea. Seems like new chats are in messages, but old chats are in chats.

Curious what tasks the rest of the team do to clean-up.
PS: Absolutely not a space issue, but privacy, I really don't want to be storing old chats.