Re: Much Ado About COUNT(*)

>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
   Tom> People who hang around Postgres too long tend to think that   Tom> MVCC is the obviously correct way to do
things,but much of   Tom> the rest of the world thinks differently ;-)
 

It works the other way too ... people who come from the locking world
find it difficult to wrap their heads around MVCC. A big part of this
is because Gray's original paper on transaction isolation defines the
different levels based on what kind of lock acquisitions they involve. 

A very nice alternative approach to defining transaction isolation is
"Generalized isolation level definitions" by Adya, Liskov and O'Neill
that appears in ICDE 2000. 

-- 
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh