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

From: Gregory Stark <gsstark(at)mit(dot)edu>
To: Hannu Krosing <hannu(at)skype(dot)net>
Cc: Gregory S Stark <gsstark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Better name/syntax for "online" index creation
Date: 2006-07-26 17:23:45
Message-ID: 87u0542sbi.fsf@stark.xeocode.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hannu Krosing <hannu(at)skype(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-07-26 17:35:34 Re: [PATCH] Provide 8-byte transaction IDs to user level
Previous Message Bruce Momjian 2006-07-26 17:15:45 Re: [HACKERS] Patch for VS.Net 2005's strxfrm() bug