PostgreSQL "activity" table grows large: Configurable Activity Cleanup Duration · GitHub Issue #3103 · LemmyNet/lemmy

github.com Configurable Activity Cleanup Duration · Issue #3103 · LemmyNet/lemmy

Did you check to see if this issue already exists? Is this only a single feature request? Do not put multiple feature requests in one issue. Is this a question or discussion? Don't use this, use ht...

The activity has a lot of data in each row.

3 comments

If indeed it is mainly used for debugging, it might make sense to have a parameter to not write data to it at all. In cases of cloud computing where database storage is limited and/or resources cycles of storage I/O or CPU load by PostgreSQL, turning off activity table logging in the code could save some site operators money and fit on smaller systems.
It was owner/operator activity today over at midwest.social instance that had me digging around on the 'activity' table. reference: https://midwest.social/post/369505

You will also see users of that instance reporting Lemmy site failures/errors in comments on that posting.