Postgres Pro
Downloads
Home   >   mailing lists

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

From Gregory Stark
Subject Re: Better name/syntax for "online" index creation
Date
Msg-id 87u0542sbi.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Better name/syntax for "online" index creation  (Hannu Krosing <hannu@skype.net>)
Responses Re: Better name/syntax for "online" index creation  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Patch for VS.Net 2005's strxfrm() bug
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] [PATCH] Provide 8-byte transaction IDs to user level