wakoinc on Nostr: My events table is 33GB. This is the largest pubkeys only. Majority is far less. I ...
My events table is 33GB. This is the largest pubkeys only. Majority is far less.
I like to look at it more like, to download all (known to me) historic events for @cameri, including stale kind 0/3, it’s only 14MB thus far.
Main issue is I rate limit on my relay, but when reading other relay feeds they often don’t have rate limits set - so I ended up with a lot of junk events from scripts/bots/spam. It’s a relay aggregation issue - as you can’t also limit or block IPs.
All events are uniqued tho. And maybe 10MM spam events dropped (I don’t keep strict count).
86,400 sec/day. Rate limiting 60/min would be fair.. even low. It’s easy for automated event creation to quickly blow up.
I like to look at it more like, to download all (known to me) historic events for @cameri, including stale kind 0/3, it’s only 14MB thus far.
Main issue is I rate limit on my relay, but when reading other relay feeds they often don’t have rate limits set - so I ended up with a lot of junk events from scripts/bots/spam. It’s a relay aggregation issue - as you can’t also limit or block IPs.
All events are uniqued tho. And maybe 10MM spam events dropped (I don’t keep strict count).
86,400 sec/day. Rate limiting 60/min would be fair.. even low. It’s easy for automated event creation to quickly blow up.