Re: Online index builds - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Online index builds
Date
Msg-id 200608011320.k71DK3303480@momjian.us
Whole thread Raw
In response to Re: Online index builds  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera wrote:
> Bruce Momjian wrote:
> > Andrew Dunstan wrote:
> 
> > > It's not particularly clear to me. On its face this seems to me to imply 
> > > something about how the index will be able to be used, not about how it 
> > > is to be built.
> > 
> > Yea, that was always a confusion.  CREATE CONCURRENT INDEX has the same
> > problem.  We need something that talks about the build-time behavior. 
> 
> How about
> 
> CREATE INDEX CONCURRENTLY?

Yea, that actually sounds pretty good.  Though a new keyword, it might
be the best solution.

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Online index builds
Next
From: Teodor Sigaev
Date:
Subject: Re: User-defined typle similar to char(length) varchar(length)