diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-07-02 02:23:23 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-07-02 02:23:23 +0000 |
| commit | 277807bd9eba1645d8dfc9252fa29220c4a83751 (patch) | |
| tree | fb3dca975d8371bd42e9e58d0b841db3fd6c4654 /doc/src/sgml/ref/create_index.sgml | |
| parent | 5d5c1416bf03efcf13cfd3b8f68a0bba199d70af (diff) | |
| download | postgresql-277807bd9eba1645d8dfc9252fa29220c4a83751.tar.gz | |
Add FILLFACTOR to CREATE INDEX.
ITAGAKI Takahiro
Diffstat (limited to 'doc/src/sgml/ref/create_index.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 676fa8b4e6..787184a5e2 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_index.sgml,v 1.52 2005/11/07 17:36:44 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_index.sgml,v 1.53 2006/07/02 02:23:17 momjian Exp $ PostgreSQL documentation --> @@ -22,6 +22,7 @@ PostgreSQL documentation <synopsis> CREATE [ UNIQUE ] INDEX <replaceable class="parameter">name</replaceable> ON <replaceable class="parameter">table</replaceable> [ USING <replaceable class="parameter">method</replaceable> ] ( { <replaceable class="parameter">column</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [ <replaceable class="parameter">opclass</replaceable> ] [, ...] ) + [ WITH (FILLFACTOR = <replaceable>fillfactor</replaceable>) ] [ TABLESPACE <replaceable class="parameter">tablespace</replaceable> ] [ WHERE <replaceable class="parameter">predicate</replaceable> ] </synopsis> @@ -172,6 +173,15 @@ CREATE [ UNIQUE ] INDEX <replaceable class="parameter">name</replaceable> ON <re </varlistentry> <varlistentry> + <term><replaceable class="parameter">fillfactor</replaceable></term> + <listitem> + <para> + The index's fillfactor in percentage. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><replaceable class="parameter">tablespace</replaceable></term> <listitem> <para> |