nostr:npub1z5rxmrt9l59y2256e5kzmfj44ydpnhgj04dq6qumjvwehe2pk30qz4rjcc Right now I'm mostly just running a script that nostr:npub1jpr9ymkz22yxvcrm2xx9zsfnyhhvsxqpnfs347n6f0mqwsmkmmls05jdqt wrote to delete remote files older than 3 weeks. Beyond that, I think PostgreSQL performs autovacuum by default? I don't know, unsure how to really check and find out. Something more to research/read about when I get some extended downtime on my computer. 

Otherwise, I occasionally run VACUUM ANALYZE manually. Might be nice to combine the script you made for pg_dump with one that can perform VACUUM ANALYZE so that the database gets dumped, vacuumed, and analyzed daily + older files get pruned daily + the server reboots daily (right now all my VMs reboot daily). nostr:npub1v7t4yx9vxtv3mat0hdsduuym4fvjd5dzmdlh82ssa40phr965h2s2lck6k nostr:npub1p5qy72ydyxlnyehhqtjdf8ve9aegr30nfu0tan4424eyvjdmd27sg8q5r0