| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Greg Stark <gsstark(at)mit(dot)edu>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Online index builds |
| Date: | 2006-08-01 11:54:15 |
| Message-ID: | 44CF40E7.6080300@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-08-01 12:18:30 | Re: Online index builds |
| Previous Message | Andrew Dunstan | 2006-08-01 11:50:22 | Re: [HACKERS] float8 regression failure (HEAD, cygwin) |