Hacker News new | ask | show | jobs
by handfuloflight 24 days ago
What are your thoughts on how design changes if writes become much heavier, ie. when recording agent operations?
1 comments

I think we have a lot of DBs specialised for heavy write, like anything with LSM-tree in their base.

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.