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