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

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: Better name/syntax for "online" index creation
Дата
Msg-id 87u0542sbi.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Better name/syntax for "online" index creation  (Hannu Krosing <hannu@skype.net>)
Ответы Re: Better name/syntax for "online" index creation  (Hannu Krosing <hannu@skype.net>)
Список pgsql-hackers
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.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] Patch for VS.Net 2005's strxfrm() bug
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [PATCHES] [PATCH] Provide 8-byte transaction IDs to user level