$ cd lemmy-dir
$ du -sh *
456K lemmy-ui
15G pictrs
4.3G postgres
Guys this is no longer funny please I feel literally chased by the “no space left” message. Please help I don’t need those pics I did not upload them
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I’ve seen in this thread:
Fewer Letters More Letters NUC Next Unit of Computing brand of Intel small computers SSD Solid State Drive mass storage VPS Virtual Private Server (opposed to shared hosting)
3 acronyms in this thread; the most compressed thread commented on today has 8 acronyms.
[Thread #73 for this sub, first seen 21st Aug 2023, 23:45] [FAQ] [Full list] [Contact] [Source code]
I ran this query:
select distinct thumbnail_url as url from post where not local and thumbnail_url like 'https://campfyre.nickwebster.dev/pictrs%'
(replace with your instance’s url)
I then sent delete requests to /internal/purge on pictrs to delete all of those old thumbnails, which cleared out a lot of space. After deleting the thumbnails I ran an
UPDATE
query to set all of those old thumbnail URLs tonull
in the DB. I also patched the version of lemmy that I run to stop caching thumbnails in the future. Hope this helps!