pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Fred C. Richards <fcr@erols.com>
To: pgsql-sql@postgresql.org
Subject: Implementing transactions (reference)
Date: Fri, 21 Aug 1998 12:26:18 -0400
Message-ID: <35DD9FAA.52C4F900@erols.com> (raw)

I would like to learn some more about how transactions are implemented
in SQL databases, specifically about what goes on behind the scene when
you start a new transactions, do some operations, and finally commit the
operations. In particular, I'd like to understand how the database
programmers make this happen. It seems like every transaction requires a
"parallel reality" for the database until it is finally committed.

Is there some definitive database textbook that addresses this topic
that would help an inquisitive person (and experienced programmer)
understand what's going on behind the scenes? Does PostgreSQL follow the
canonical standard? Where in the code would I start looking to
understand this better?

-Fred



Message-ID: <35DD9FAA.52C4F900@erols.com>
Permalink:  ../35DD9FAA.52C4F900@erols.com/
Also on:    postgresql.org/message-id/35DD9FAA.52C4F900@erols.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: fcr@erols.com
  Subject: Re: Implementing transactions (reference)
  In-Reply-To: <35DD9FAA.52C4F900@erols.com>
  References: <35DD9FAA.52C4F900@erols.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox