zlacker

[parent] [thread] 2 comments
1. zinclo+(OP)[view] [source] 2023-04-26 21:23:51
I guess the question is, which MVCC strategy would be the "right" one to pick for a modern relational database? The paper linked focuses on main memory databases, and being main memory allows you to do things you can't do when disk based.
replies(1): >>avinas+YQ
2. avinas+YQ[view] [source] 2023-04-27 04:59:35
>>zinclo+(OP)
I have same the question. I skimmed through the linked paper for conclusion, they highlight the techniques which can be used to improve, but does not say which MVCC to use for a modern database. May be I need to do a careful reading.
replies(1): >>zinclo+hu2
◧◩
3. zinclo+hu2[view] [source] [discussion] 2023-04-27 15:43:17
>>avinas+YQ
I took a look at https://github.com/orioledb/orioledb which is a project attempting to remedy some of Postgres' shortcomings, including MVCC. It looks like they're doing something similar to MySQL with a redo log, as well as some other optimizations. So maybe this is the answer.
[go to top]