this post was submitted on 26 Feb 2025
98 points (99.0% liked)

Fediverse memes

803 readers
264 users here now

Memes about the Fediverse

Other relevant communities:

founded 5 months ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 5 points 21 hours ago (1 children)

By far the most space is taken up by votes. You can disable votes (1.0 will have more options), or delete them directly from the database.

[–] [email protected] 2 points 21 hours ago (1 children)

Yeah I guess the issue is that votes are the thing that makes Lemmy what it is. Without them it's just a stream of posts with no ranking. Hard to avoid needing that space.

It's not a huge amount of space, but if you're on a cheap VPS then they don't come with much space.

[–] [email protected] 4 points 20 hours ago (2 children)

You could write a query to votes for remote posts older than 6 months, or something similar.

[–] [email protected] 3 points 20 hours ago

True, that would probably help a lot.

[–] [email protected] 1 points 19 hours ago (1 children)

Or instead of individual votes do a dump like an rss. Like only update when I ask every 10 minutes or so. Get everything from x - y time and just give me the totals. Probably only good for smaller instances though.

[–] [email protected] 1 points 10 hours ago

Its not that easy because users can undo their votes, or change an upvote to downvote. Thats why we store every individual vote in the database. Also votes from defederated instances are discarded, which wouldnt work if there is only a total vote count from the community. And in general Activitypub is push-based, not pull-based.