←back to thread

MVCC – the part of PostgreSQL we hate the most (2023)

(www.cs.cmu.edu)
366 points virtualwhys | 1 comments | 20 Oct 24 15:30 UTC | HN request time: 0.001s | source
Show context
nightfly ◴[20 Oct 24 18:26 UTC] No.41897421[source]▶
> MySQL and Oracle store a compact delta between the new and current versions (think of it like a git diff).

Doesn't git famously _not_ store diffs and instead follows the same storage pattern postgres uses here and stores the full new and old objects?

replies(6): >>41897457 #>>41897486 #>>41897759 #>>41897885 #>>41899164 #>>41899189 #
ChadNauseam ◴[20 Oct 24 18:36 UTC] No.41897486[source]▶
TBF, the quoted section doesn't say that git stores diffs (or anything about git storage), it just says that what MySQL and Oracle stores is similar to a git diff.
replies(2): >>41900208 #>>41906576 #
1. zdragnar ◴[21 Oct 24 02:34 UTC] No.41900208[source]▶
It's a little too easy to misinterpret if you're skimming and still have memories of working with SVN, mercurial, perforce, and probably others (I've intentionally repressed everything about tfvc).