Re: Choosing a Transaction Isolation Level

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Adam Sherman <adam(at)tritus(dot)ca>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Choosing a Transaction Isolation Level
Date: 2003-05-14 17:38:41
Message-ID: Pine.LNX.4.33.0305141133360.31454-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 14 May 2003, Adam Sherman wrote:

> How should one choose a Transaction Isolation Level?

Well, first, read up a bit here:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=transaction-iso.html

Basically, the philosophy goes like this:

Serializable treats every select kinda like a "select for update" in that
if what you selected in the first line changes by the third line, the
transaction

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-05-14 17:39:09 Re: Choosing a Transaction Isolation Level
Previous Message greg 2003-05-14 17:31:18 Re: fomatting an interval (resend)