←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.201s | source
Show context
derefr ◴[20 Oct 24 19:12 UTC] No.41897751[source]▶
Question: is storing full new row-tuple versions something fundamental to Postgres as a whole, or is it just a property of the default storage engine / “table access method”?
replies(2): >>41897917 #>>41898523 #
1. paulddraper ◴[20 Oct 24 19:37 UTC] No.41897917[source]▶
You could store partial tuples without disrupting the interface.

Though full tuples is pretty fundamental to the underlying implementation....MVCC, VACUUM, etc. It'd be a massive change to say the least.