search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.94k stars 1.06k forks source link

Consider Serializable Snapshot Isolation (SSI) implementation in PostgreSQL for YugabyteDB #6493

Open triump2020 opened 3 years ago

triump2020 commented 3 years ago

Hi team ! It seems that the reads of a serializable transaction also must replicate the read-locks(read intents )through raft consensus as same as the writes . So I' m somewhat worried about its perfromance of a serializable transaction , there would to be some plans to optimize it in the future ? Or YB would take SSI implementation into consideration in the future ? Thanks !

ddorian commented 3 years ago

@rkarthik007

rkarthik007 commented 3 years ago

Hi @triump2020,

I have been researching this a bit, SSI implementation in PostgreSQL looks really interesting. So we are going to take this up for design discussions, and will keep you posted on the progress here. I am changing the title of this GitHub to reflect this (hope thats ok).

Here are some good resources I have been using to research this topic, adding here for completeness: [1] PostgreSQL wiki on SSI [2]Transaction isolation docs of PostgreSQL [3] The Serializable Snapshot Isolation in PostgreSQL VLDB paper [4] https://courses.cs.washington.edu/courses/cse444/08au/544M/READING-LIST/fekete-sigmod2008.pdf [5] https://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.307.6793&rep=rep1&type=pdf