Lessons learned from sharding Postgres at Notion

Re:Lessons learned from sharding Postgres at Notion by bamazizi on Wednesday October 06, 2021 @03:43PM (#28777443)

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?

[ Parent | on HN ]

Re:Lessons learned from sharding Postgres at Notion by dilyevsky on Wednesday October 06, 2021 @06:46PM (#28779455)

Totally 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

[ Parent | on HN ]

Re:Lessons learned from sharding Postgres at Notion by akarki15 on Wednesday October 06, 2021 @04:21PM (#28777938)

+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?

[ Parent | on HN ]