What are your thoughts on how design changes if writes become much heavier, ie. when recording agent operations?
My vision is that there will be more movement in this direction, but still, we need first to understand limits of "easy to work with" databases like Postgres. It's easy to underestimate what Postgres can do.
And only when it's not enough, move to something LSM-tree-based.