Horton

Re: "serializable" in comments and names

Bruce Momjian <bruce@momjian.us>

View thread
From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alvaro Herrera <alvherre@commandprompt.com>, Kevin Grittner <kevin.grittner@wicourts.gov>, Dan Ports <drkp@csail.mit.edu>, Robert Haas <robertmhaas@gmail.com>, "<pgsql-hackers@postgresql.org>" <pgsql-hackers@postgresql.org>
Date: 2010-09-08T16:51:11Z
Lists: pgsql-hackers 
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> > Excerpts from Kevin Grittner's message of vie sep 03 19:06:17 -0400 2010:
> >>> How about IsolationUsesXactSnapshot
> 
> > I find this name confusing :-(  Doesn't a READ COMMITTED transaction use
> > transaction snapshots as well?
> 
> AFAIR it doesn't keep the first snapshot around.  If it did, most of
> your work on snapshot list trimming would have been useless, no?

Technically, serializable uses a single transaction snapshot and read
committed uses statement snapshots.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +