Seeing how PITR, nested transactions, and other exciting developments related to transactions are being developed, I am getting curious about how PostgreSQL actually implements transactions. Investigating Materialized Views has led me to look closely at how transactions work and such.
Do you know of good resources on learning how transactions are implemented in PostgreSQL? Should I just peruse the code? Which files are most relevant?
Next to diving into the code you might want to dive into the theory. Chapter 5 of "Concurrency Control and Recovery in Database Systems" deals with Multi Version Concurrency Control: http://research.microsoft.com/pubs/ccontrol/
Jochem
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
