News for hackers. Stuff that matters.
Re:Moving from relational data to events by refset on Saturday December 16, 2023 @12:13PM (#38665897)
"normalize until it hurts, denormalize until it works" is evergreen advice for scaling both reads and writes. Synchronously enforcing referential integrity and other forms of normalized constraints is what gets expensive.

Pat Helland has some really good writing on this stuff, e.g. https://pathelland.substack.com/p/i-am-so-glad-im-uncoordina...

Re:Moving from relational data to events by ldng on Saturday December 16, 2023 @12:36PM (#38666136)
And in between, at the coma, revise seriously your indexing policy and don't hesitate to remove unused and underused index (even on foreign key if you don't need them that much). People too often underestimate the impact of rebuilding and index on large inserts.
Re:Moving from relational data to events by refset on Saturday December 16, 2023 @07:38PM (#38669254)
Absolutely, there's no beating the RUM Conjecture.