what is stored in received_activity ? anything important? I mean obviously it’s something the instance has received from other instances but is this then stored somewhere else (like comments then stored elsewhere for eg)
Comment on How can I reduce the amount of storage used by my Lemmy instance?
bdonvr@thelemmy.club 10 months ago
Firstly move pict-rs to object storage. My instance’s pict-rs uses 130GB alone. I pay less than $2/mo to put it on Cloudflare R2. Backblaze B2 might be even cheaper. Instructions: crates.io/crates/pict-rs#filesystem-to-object-sto…
If that doesn’t help enough and you’re comfortable with SQL, you can purge the unnecessary entries in received-activities.
Command: delete from received_activity where published < NOW() - INTERVAL ‘3 days’;
Then do a vacuum full received_activity; to reclaim the space.
This deleted 98 million entries for me and reduced my database size from 49GB to 20GB a week ago when ai started running out of space. No other effect as far as I can tell. Thanks @illecors@lemmy.cafe
MrRazamataz@lemmy.razbot.xyz 10 months ago
bdonvr@thelemmy.club 10 months ago
As far as I’ve been told it’s basically just a log of all received activities. Nothing references it.
Die4Ever@programming.dev 10 months ago
in v0.19.0 Lemmy will automatically delete entries over 7 days old
TrinityTek@lemmy.world 10 months ago
Thank you, that SQL command looks like exactly what I’m after! I’m going to give that a shot. I appreciate the help!