Re: Choosing a Transaction Isolation Level

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