PostgreSQL's MVCC is bad. So is everyone else's (boringsql.com)

I'm surprised that Interbase/Firebird seems to be entirely omitted from this despite pioneering the MVCC approach.

I'm conflicted with this article. It does pack a lot of good information in there, and it's a useful comparison of the core difference between PostgreSQL and MySQL. But it still contains a lot of LLM-isms which are off putting and make me want to stop reading when I see them.

> Nothing was solved. The four questions got new answers, and the costs moved into the compactor.

I have been meaning to write on this topic and in relation to LSM for a while. So, I appreciated that note on LSMs. There are no free ~lunches~ reads or writes.

Dupe of https://news.ycombinator.com/item?id=49078196 which was posted a couple days ago, and then seemingly revived in second chance pool before getting flagged for obvious slop-tone.

OP, here thank you for comments and while I might not like it to be called LLM - I give up.

[dead]