On: Streaming data in Postgres to 1M clients with Grap...

[dagss]

This is my favorite kind of schema -- do not UPDATE Person.Name, instead INSERT into PersonNameChange.

With the right indexes and lateral joins/cross applies you can make the aggregate you need when you query instead of when you write.