Re: Understanding transactions

From: Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl>
To: Jonathan Gardner <jgardner(at)jonathangardner(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Understanding transactions
Date: 2004-06-04 10:49:20
Message-ID: 40C053B0.8060304@oli.tudelft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2004-06-04 11:50:19 Re: [HACKERS] Slony-I goes BETA
Previous Message Marko Karppinen 2004-06-04 10:10:02 Re: Converting postgresql.conf parameters to kilobytes