Re: Online index builds - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Online index builds
Date
Msg-id 44CF40E7.6080300@dunslane.net
Whole thread Raw
In response to Re: Online index builds  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Online index builds
List pgsql-hackers
Bruce Momjian wrote:
> Consindering the syntax for this, we currently allow read access during
> index creation, just not write access, so I think the new syntax should
> be:
>
>     CREATE [ UNIQUE ] INDEX name  ON table 
>         [ USING method ] [ [ENABLE] WRITE [ACCESS] ]
>         ( { column | ( expression ) } [ opclass ] [, ...] )
>         [ WITH ( storage_parameter = value [, ... ] ) ]
>         [ TABLESPACE tablespace ]
>         [ WHERE predicate ]
>
> This is clear, and adds no new keywords.
>
>   

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.

cheers

andrew


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: float8 regression failure (HEAD, cygwin)
Next
From: Bruce Momjian
Date:
Subject: Re: Online index builds