Re: Better name/syntax for "online" index creation

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Better name/syntax for "online" index creation
Дата
Msg-id 1153952505.2928.51.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Better name/syntax for "online" index creation  (Gregory Stark <gsstark@mit.edu>)
Ответы Re: Better name/syntax for "online" index creation  (Paul Silveira <plabrh1@gmail.com>)
Список pgsql-hackers
Ü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 по дате отправления:

Предыдущее
От: "Paul S"
Дата:
Сообщение: Re: Better name/syntax for "online" index creation
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [PATCHES] [PATCH] Provide 8-byte transaction IDs to