jleger2023 on Nostr: Just deleted another 150,000 spam posts from NostrGram's database. The performance ...
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.
Published at
2023-02-20 00:55:20Event JSON
{
"id": "ec17e18bb76f2b4a6eb4f5afaa32b7abb8f0e33d97edf8f6cd74b3e16b93a3cb",
"pubkey": "597b42de56a9e0c19ee2d0cde5797dd58d48ce8dd25c732b4c873af11161f9fd",
"created_at": 1676854520,
"kind": 1,
"tags": [],
"content": "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.",
"sig": "fc8705cee46ef938fba42b57060f787f94c8b2147daac301d5dcef50b0f431d0093775533186833f2fa9c5d4eecb113c7095e910916d8b57422f719de25f27fe"
}
