Lessons learned from sharding Postgres at Notion

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 ]