The largest table holds data that is only needed by Lemmy briefly. There is a scheduled job to clear it... Every 6 months. There are active discussions on how best to handle this.
On my instance I've set a cronjob to delete everything but the most recent 100k rows of that table every hour.
By the way, upgradding to lemmy version 0.18.1 is well worth it. Some massive under the hood performance improvements 🙂
Mate, that sounds like an awesome night. I'd call that a win!
Your mum was a programmer in the 60s? She must be incredibly in so many ways!
Ok yeah, I guess for external links direct to images it makes sense for the image to be retrieved by each instance. Still, its not intuitive behaviour and it doesn't seem to be widely understood at all.
Thanks for reporting back.
Thanks, modded.
Sure, modded.
Have you raised an issue on github for this? Its the best way to inform the devs.
It may be a bug, I'm not sure.
On 0.18.1-rc.10 the defederated instances are at the very bottom, not on the right hand side.
Thanks, modded.
Definitely, I understand some people would not want this.