4 ms·
I am assuming your product is HockeyStack. Why do you need Clickhouse? Why do you need to store 20 billion rows of data? Even if you do need to store that much
by altdataseller 2y ago
I am assuming your product is HockeyStack.
Why do you need Clickhouse? Why do you need to store 20 billion rows of data? Even if you do need to store that much, why isnt something like Postgres sufficient?
If you’re doing revenue attribution based on things like website visits, or activities, and only have hundreds of customers, then i imagine at worse you are processing a thousand events every few seconds? Mostly writes. Seems you can do something around caching events and bulk inserting to optimize things. Still think using Postgres is possible here. If you need to scale horizontally, you could shard based on customer ID too. If you need to do analytics on this data, Postgres should still be usable as long as you create the right indices