PostgreSQL's MVCC is bad. So is everyone else's

gtowey 10 minutes ago | parent | next [-]

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.

	▲	dbt00 3 minutes ago \| parent \| next [-]
		Same. It's really hard to fight the tic now where I just automatically close the tab when I get to the second or third thing, and it's only the first paragraph. Please, write your own prose.
	▲	radimm 4 minutes ago \| parent \| prev [-]
		OP here, thanks for the feedback. Just curious - anything specific? I spent long time getting to some sort of framework for my writing and being called LLM is my constant struggle. PS: I do use LLM for polish, etc.

▲

shayonj 9 minutes ago | parent | prev | next [-]

> 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.

▲

jhgb 28 minutes ago | parent | prev | next [-]

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

▲

radimm 18 minutes ago | parent [-]

OP here, I acctually had Firebird listed in some version of my draft, but had to make a natural cut somewhere.

▲

jhgb 17 minutes ago | parent [-]

I see. I guess that makes sense, popularity-wise. I imagine the results were in the vicinity of PostgreSQL anyway, considering the similarity of approaches.

▲

radimm 12 minutes ago | parent [-]

I had to make a cut - and that's also a reason why etcd got mentioned - focused on what most people today know.

	▲	gjvc 3 minutes ago \| parent [-]
		[delayed]

▲

evanelias 3 minutes ago | parent | prev [-]

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.