Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group