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

From Rod Taylor
Subject Re: MS SQL features for new version
Date
Msg-id 1076445630.321.1.camel@jester
Whole thread Raw
In response to MS SQL features for new version  (Shridhar Daithankar <shridhar@frodo.hserus.net>)
Responses Re: MS SQL features for new version
Re: MS SQL features for new version
Improved index creation (was:MS SQL features for new version)
List pgsql-hackers
On Tue, 2004-02-10 at 15:37, Robert Treat wrote:
> 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;

Well.. If thats a big table, you've just blocked selects, updates,
delete, inserts, etc. against that table for the duration of the index
recreation.

Their text indicates that all activity on the table will not be blocked
during the creation of a new index on that table. To me, that makes it a
slick trick.



pgsql-hackers by date:

Previous
From: Rod Taylor
Date:
Subject: Re: MS SQL features for new version
Next
From: Robert Treat
Date:
Subject: Re: MS SQL features for new version