My pictrs volume got quite huge and I wanna delete pics cached from other instances. The thing is I'm not sure which pics are from my instance and which aren't, because they all have cryptic filenames. Anyone knows of a way to differentiate?
Maybe you have to crossmatch db content to files (with a script) and remove anything that is not relevant? I don't manage instance, so i might be completely off.
I would recommend Backblaze B2 storage instead of removing post history.
The problem with post removal is that it will affect all other instances' as you don't (by default) cache original images from other fediverse instances (iirc)
So for example, my instance Reddthat will reference an image hosted on your instance, which will then 404. (But the thumbnail will be cached (I think))
Backblaze is dirt cheap and the pictrs object migration is now multi threaded making it very easy to migrate now.
I was hosting 15GB and it amounted to bills of cents! $5/TB or $0.005 per GB.
If you add CloudFlare Infront you then get free egress! Or any CDN that is part of the "Bandwidth alliance".
I now have ~120GB of pictrs storage. After 2-3 months.
Also, there was a recent chat on the lemmy admin matrix channel about setting some variable in pictrs so it does not cache any images. But I don't remember what it was so maybe check the pictrs documentation.
Do you put cloudflare between the VPS and Backblaze or is their website just referring to "CDN and compute partners" between the VPS and the end users? ... Or both?
Because Lemmy does not have a way to have all media served from a different url/subdomain (like a CDN). Your setup will be:
cloudflare > vps
vps > backblaze
Basically just put cloudflare infront of your vps, and cache everything.
That means if a user uploaded a 10MB file, it would go though your VPS, get uploaded to backblaze. When a user looks at the uploaded image url, on the first request it gets requested from blackblaze, via your vps, and then gets cached on Cloudflare.
Then any extra requests from then on will be via Cloudflare. So you will technically be charged for some api requests and 1x 10MB of egress traffic.