upvote
You are correct! And sadly the vast majority of people don't want to make choices or think about that tradeoff.

If it can't outperform pure OLTP and it can't outperform pure OLAP then there is no pit of success for such an HTAP system.

The unfortunate part is that the vast majority of software out there in the world would be served perfectly with an HTAP solution.

The fortunate part is that for a lot of problems you can just run Postgres and then when you need analytics you can still use Postgres, until you hit scaling issues (if ever).

I've never seen a project choose to solve OLAP and OLTP upfront and succeed.

reply