Re: MS SQL features for new version - Mailing list pgsql-hackers

From Robert Treat
Subject Re: MS SQL features for new version
Date
Msg-id 1076445449.17920.26.camel@camel
Whole thread Raw
In response to Re: MS SQL features for new version  (Rod Taylor <pg@rbt.ca>)
List 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



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: MS SQL features for new version
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Current-stream read for psql's \copy