Re: Understanding transactions

Jonathan Gardner wrote:
> 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