Someone else may provide more specific/deep help but I wanted to flag Asya’s comment on Efficient Structure for Social Media Feeds (fan-out on write)? - #3 by Asya_Kamsky as it may include some helpful links / a reference architecture related to what you’re doing