Just deleted another 150,000 spam posts from NostrGram's database. The performance changes from earlier today are really shining right now. There's virtually zero wait on any query being sent to it. Roughly half the events coming in from the relays being indexed are blocked because of having known spam links in their content. Sheesh.
Discussion
🔥💪🙏
Would be good if we could get some info on which relays are the worst offenders for carrying spam
I need to run some metrics on that and see. Next time I do a spam sweep I'll see if I can tabulate the most common relays responsible for the spam. One thing I can promise you -- it's not the paid ones. That's the ultimate solution to the spam issue imo.
I deleted several relays that I used (currently I still only use free relays) and I received a lot of spam. Interestingly, I was thinking of doing a similar test today.
Agree paid relays are the solution but there’s probably some low-hanging fruit URL blocking that could be added to pihole-type lists that relays could access.
This is turning out to be a big deal more quickly than expected (I think). Anyway, I noticed that spam prevention is on the #nostrica agenda. Watching this closely because I’ve been planning to set up a relay in the near future.
