Hey sorry the post wasn’t more well written! I tried to cover all the basic or obvious approaches (counter, assoc table) so that people could see the complexit

Hey sorry the post wasn’t more well written! I tried to cover all the basic or obvious approaches (counter, assoc table) so that people could see the complexity kind of ramp up. You’re right that an assoc table is a very workable solution, along with the partitioning capabilities of postgres these days.