I’ve been pondering this too.
How micro you thinking? Basically map event_id to relays that broadcast it (don’t event store the event), or map a pubkey to the latest kind 0/3/10023 events known? Both?
Because Nostr doesn’t have a HEAD concept, certainty around ‘newest’ meta events is hard to make foolproof.