Postgres Pro
Downloads
Home   >   mailing lists

Re: Better name/syntax for "online" index creation - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Better name/syntax for "online" index creation
Date
Msg-id 1153952505.2928.51.camel@localhost.localdomain
Whole thread Raw
In response to Re: Better name/syntax for "online" index creation  (Gregory Stark <gsstark@mit.edu>)
Responses Re: Better name/syntax for "online" index creation
List pgsql-hackers
Tree view 
Ühel kenal päeval, K, 2006-07-26 kell 13:23, kirjutas Gregory Stark:
> Hannu Krosing <hannu@skype.net> writes:
> 
> > Ühel kenal päeval, K, 2006-07-26 kell 06:40, kirjutas Gregory S Stark:
> > > The DB2 handbook says "Tables can now be reorganized online with almost full
> > > acess to the table allowed" but their syntax does not use the word "online".
> > 
> > Does this reorganizing refer to what we do with CLUSTER ?
> > 
> > I'd really love to be able to CLUSTER a table with ALLOW WRITE ACCESS.
> 
> It's hard for me to tell from this handbook but it sort of seems like what
> you're looking for is "IN PLACE" for which the default is ALLOW WRITE ACCESS.

IN PLACE CLUSTER would be sweet. 

Do you know of anyone who would be willing to do it for postgresql ? 

Preferrably for 8.2 :)


-- 
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me:  callto:hkrosing
Get Skype for free:  http://www.skype.com

pgsql-hackers by date:

Previous
From: "Paul S"
Date:
Subject: Re: Better name/syntax for "online" index creation
Next
From: Andrew Dunstan
Date:
Subject: Re: [PATCHES] [PATCH] Provide 8-byte transaction IDs to