What does a backing data lake afford a Notion user that can’t be done in a similar product, like Obsidian?
What does a backing data lake afford a Notion user that can’t be done in a similar product, like Obsidian?
When your data is in Postgres, running an arbitrary query might take hours or days (or longer). Postgres does very poorly for queries that read huge amounts of data when there's no preexisting index (and you're not going to be building one-off indexes for ad hoc queries—that defeats the point). A data warehouse is slower for basic queries but substantially faster for queries that run against terabytes or petabytes of data.
I can imagine some use cases at Notion:
- You want to know the most popular syntax highlighting languages
- You're searching for data corruption, where blocks form a cycle
- You're looking for users who are committing fraud or abuse (like using bots in violation of your tos)
It can also be used to train AI models, of course.