Re: Comparison of PGSQL and DB2

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, Peter Eisentraut <peter_e(at)gmx(dot)net>, <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Comparison of PGSQL and DB2
Date: 2004-03-11 21:16:01
Message-ID: Pine.LNX.4.33.0403111410260.17865-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

On Thu, 11 Mar 2004, Bruno Wolff III wrote:

> On Thu, Mar 11, 2004 at 14:21:09 -0500,
> Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> wrote:
> > On Thu, 2004-03-11 at 13:59, Peter Eisentraut wrote:
> > > Josh Berkus wrote:
> > > > > Isolation Levels
> > > > > (Support all four ANSI isolation levels (UR, CS, RS, RR).)
> > > >
> > > > I'm not sure about this one; I suspect that we do, however, since
> > > > MVCC, invented for the Postgres Project, has become a standard for
> > > > transaction isolation in the database industry.
> > >
> > > 7.5 will support all four isolation levels.
> > >
> >
> > I wasn't aware of anyone doing work on this... do you have any more
> > info?
>
> My memory of past discussion on this is that you would be able to set all
> 4 transaction isolation levels in a command, but you would really get
> the next level up for the two that we don't provide. This is OK since
> since they get at least the transaction isolation safety they need.
> The reason for doing this is portability.

I thought the other two were considered meaningless within the context of
MVCC... I.e. they were defined when row locking was the standard way of
storing data, and reflect that, and MVCC changed the rules so much that
the other two, which were a cheaper to implement locking model in a row
locking database, became no cheaper, and therefore there was no reason go
program a way to expose the data the way that locking model defined, since
doing so would provide poorer data integrity while actually being the same
speed or slower.

Or something like that.

So, are those isolation levels being actually implemented, or are we just
pretending to set the level in 7.5 but still using the next level higher?

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Marc G. Fournier 2004-03-11 21:29:28 Re: Org Types, was: The big MySQL spin
Previous Message Jonathan Gardner 2004-03-11 20:46:44 Re: ZDNet story (well, publicity from some research company)