curious if anyone has advice on tables where rows are removed on a rolling basis. my main considerations here:
1. is it generally safe to, for example, execute a trigger to remove rows once the count of rows (for example, number of notifications for a user) exceeds a threshold? This is supposing that the number of rows to be removed is pretty low, and the frequency this gets executed is also relatively low.
2. does hosted supabase run autovacuum? if I'm regularly deleting rows like this, is my DB size going to keep expanding until I manually run VACUUM?