Lessons learned from sharding Postgres at Notion

Re:Lessons learned from sharding Postgres at Notion by StreamBright on Wednesday October 06, 2021 @05:34PM (#28778771)

I would try to use a simple k:v system that is much easier to scale. Even S3 would be a good candidate. Maybe I am missing the point.

[ Parent | on HN ]

Re:Lessons learned from sharding Postgres at Notion by lapaz17 on Friday October 08, 2021 @02:31AM (#28796335)

Could you explain that k:v system a little bit? Junior eng. here.

[ Parent | on HN ]

Re:Lessons learned from sharding Postgres at Notion by roguas on Sunday October 10, 2021 @10:02AM (#28818490)

KV means key value. Essentially the suggestion is to organize your data as a big key value structure(hashmap-like). This term usually means data is not normalized/separated as in regular SQL.

for instance, in SQL:

User table, that has columns: id, email

Article table, that has columns: id, text, user_id

KV/noSQL equivalent:

Article document, that has properties: id, text, user_email

[ Parent | on HN ]