@angristan I've had similar problems, but maybe on a smaller scale with single board computers. My solution is to expire posts with a configurable length of time (typically a few months). That prevents the database from becoming so large that it's difficult to back up or makes the system unstable.