Is that note database size or image cache size? I haven’t messed with the note database size but if all the cached images and media are getting too big you can change how long they’re cached for.
nostr:npub189j8y280mhezlp98ecmdzydn0r8970g4hpqpx3u9tcztynywfczqqr3tg8 was using 30GB of storage (is that expected nostr:npub1acg6thl5psv62405rljzkj8spesceyfz2c32udakc2ak0dmvfeyse9p35c ?), so I nuked it all, but then it has also deleted my key so now I'm using Coracle as my main client for a while.
Discussion
Images and videos for sure, if only %25 of the 30GB is events, you need 7.5M events. The biggest relay stores 3M events only.
It's a media cache issue.
My cache folder is using 34G. My lmdb folder is using 4.3G (I prune it, it has gotten up to 12G or so). It could be either.
The local database doesn't just store events. There are lots of other records.