Re: MS SQL features for new version

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Rodrigo <rdeleonp(at)yahoo(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: MS SQL features for new version
Date: 2004-02-17 16:55:31
Message-ID: Pine.LNX.4.33.0402170954580.30606-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 10 Feb 2004, Rodrigo wrote:

> Shridhar Daithankar wrote:
> > Just stumbled upon this. just an FYI,
> >
> > http://www.microsoft.com/sql/yukon/productinfo/top30features.asp
> >
> > Shridhar
>
> From the page:
>
> > A new Snapshot Isolation (SI) level will be provided at the
> > database level. With SI, users will be able to access the
> > last committed row using a transitionally consistent view
> > of the database. This capability will provide greater
> > scalability for very large database (VLDB) implementations.
>
> Is Snapshot Isolation == MVCC ?

I think it goes that MVCC is a kind of snap shot, but snap shotting could
be provided by more ways than just MVCC.

But I'm not 100% certain on that.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-02-17 17:45:20 log_line_info
Previous Message Bruce Momjian 2004-02-17 16:29:05 Re: DROP TABLE and concurrent modifications