Re: MS SQL features for new version

From: "Keith Bottner" <kbottner(at)comcast(dot)net>
To: "'Rod Taylor'" <pg(at)rbt(dot)ca>, "'Robert Treat'" <xzilla(at)users(dot)sourceforge(dot)net>
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 22:14:51
Message-ID: 006101c3f023$4e576da0$7d00a8c0@juxtapose
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Can't they just let the old index continue to work while generating the new
index and then after the new index is created switch? I know the details are
more complex but what would be the factor(s) preventing this?

Keith

-----Original Message-----
From: pgsql-hackers-owner(at)postgresql(dot)org
[mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Rod Taylor
Sent: Tuesday, February 10, 2004 2:41 PM
To: Robert Treat
Cc: Andreas Pflug; shridhar(at)frodo(dot)hserus(dot)net; PostgreSQL Development
Subject: Re: [HACKERS] MS SQL features for new version

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.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-02-10 22:32:52 Re: libpq thread safety
Previous Message Bruce Momjian 2004-02-10 22:08:34 Re: [PATCHES] Current-stream read for psql's \copy