3 ms·
Curious about thought on using something totally different like column oriented db, like ClickHouse, would've suited a block data oriented app like Notion bette
by bamazizi 5y ago
Curious about thought on using something totally different like column oriented db, like ClickHouse, would've suited a block data oriented app like Notion better?
Does anyone with experience have any thoughts in favour or against such implementation?
- akarki15 5y ago+1. First thought i had when i saw this was like why is notion using a postgresdb in first place- i can see it being used for customer data (which probably doesn’t require sharding) but for the content itself, a nosql or colum oriented db is better fit. the question i have is what is notion storing in these sharded postgresdb?
- dilyevsky 5y agoTotally different usecase with clickhouse - the point queries there still slower than citus but it kicks its ass on multi row aggregations. For auto-sharded oltp db cockroachdb or tidb seem like way better options