| From: | Hannu Krosing <hannu(at)skype(dot)net> |
|---|---|
| To: | Gregory Stark <gsstark(at)mit(dot)edu> |
| Cc: | 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 22:21:44 |
| Message-ID: | 1153952505.2928.51.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Ühel kenal päeval, K, 2006-07-26 kell 13:23, kirjutas Gregory Stark:
> 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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2006-07-26 22:26:11 | Re: [PATCHES] [PATCH] Provide 8-byte transaction IDs to |
| Previous Message | Paul S | 2006-07-26 21:58:57 | Re: Better name/syntax for "online" index creation |