Re: MS SQL features for new version

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>, shridhar(at)frodo(dot)hserus(dot)net, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: MS SQL features for new version
Date: 2004-02-10 20:37:29
Message-ID: 1076445449.17920.26.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2004-02-10 at 13:20, Rod Taylor wrote:
> > >http://www.microsoft.com/sql/yukon/productinfo/top30features.asp
>
> > Notice the Snapshot Isolation. Sounds like MVCC for MSSQL?
>
> Actually, the one I noticed was the ability to add or rebuild indexes on
> the fly. That is a pretty slick trick.
>

I was trying to decide how much better this was than

BEGIN;
DROP INDEX foo ON bar;
CREATE INDEX foo ON bar;
COMMIT;

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2004-02-10 20:40:31 Re: MS SQL features for new version
Previous Message Simon Riggs 2004-02-10 20:23:25 Re: [HACKERS] PITR Dead horse?