Investigate potential scalability bottlenecks

[d-linko]

• Figure out where things will break once we start to add dozens, hundreds of agents, and how we can build in scalability early. - writing tons of different things to different tables at the same time -- should we break up postgres instances?