From 277807bd9eba1645d8dfc9252fa29220c4a83751 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 2 Jul 2006 02:23:23 +0000 Subject: Add FILLFACTOR to CREATE INDEX. ITAGAKI Takahiro --- doc/src/sgml/ref/alter_index.sgml | 24 +++++++++++++++++++++++- doc/src/sgml/ref/alter_table.sgml | 24 +++++++++++++++++++++++- doc/src/sgml/ref/create_index.sgml | 12 +++++++++++- doc/src/sgml/ref/create_table.sgml | 12 +++++++++++- doc/src/sgml/ref/create_table_as.sgml | 12 +++++++++++- 5 files changed, 79 insertions(+), 5 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/ref/alter_index.sgml b/doc/src/sgml/ref/alter_index.sgml index 929f8709bab..d497dd47afb 100644 --- a/doc/src/sgml/ref/alter_index.sgml +++ b/doc/src/sgml/ref/alter_index.sgml @@ -1,5 +1,5 @@ @@ -22,6 +22,8 @@ PostgreSQL documentation ALTER INDEX name RENAME TO new_name ALTER INDEX name SET TABLESPACE tablespace_name +ALTER INDEX name SET (FILLFACTOR = fillfactor) +ALTER INDEX name RESET (FILLFACTOR) @@ -56,6 +58,26 @@ ALTER INDEX name SET TABLESPACE + + SET (FILLFACTOR) + + + This form changes the index's fillfactor to the specified percentage. + Index structure is not modified immediately; use REINDEX + to ensure reflection of the change. + + + + + + RESET (FILLFACTOR) + + + This form changes the index's fillfactor to the default value. + + + + diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index ee501a1a372..ef8e803d6f1 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ @@ -46,6 +46,8 @@ where action is one of: CLUSTER ON index_name SET WITHOUT CLUSTER SET WITHOUT OIDS + SET (FILLFACTOR = fillfactor) + RESET (FILLFACTOR) INHERIT parent_table NO INHERIT parent_table OWNER TO new_owner @@ -321,6 +323,26 @@ where action is one of: + + SET (FILLFACTOR) + + + This form changes the table's fillfactor to the specified percentage. + Table structure is not modified immediately; use CLUSTER + to ensure reflection of the change. + + + + + + RESET + + + This form changes the table's fillfactor to the default value. + + + + RENAME diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 676fa8b4e6e..787184a5e20 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -1,5 +1,5 @@ @@ -22,6 +22,7 @@ PostgreSQL documentation CREATE [ UNIQUE ] INDEX name ON table [ USING method ] ( { column | ( expression ) } [ opclass ] [, ...] ) + [ WITH (FILLFACTOR = fillfactor) ] [ TABLESPACE tablespace ] [ WHERE predicate ] @@ -171,6 +172,15 @@ CREATE [ UNIQUE ] INDEX name ON + + fillfactor + + + The index's fillfactor in percentage. + + + + tablespace diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 0276dc7ad23..c40c37c19ca 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ @@ -28,6 +28,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE tablespace ] @@ -303,6 +304,15 @@ and table_constraint is: + + WITH (FILLFACTOR = fillfactor) + + + This optional clause specifies the table's fillfactor in percentage. + + + + CONSTRAINT constraint_name diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index 7e7fa7b6731..53fb6c0971a 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -1,5 +1,5 @@ @@ -23,6 +23,7 @@ PostgreSQL documentation CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ] [ WITH OIDS | WITHOUT OIDS ] + [ WITH (FILLFACTOR = fillfactor) ] [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ] [ TABLESPACE tablespace ] AS query @@ -116,6 +117,15 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name + + WITH (FILLFACTOR = fillfactor) + + + This optional clause specifies the table's fillfactor in percentage. + + + + ON COMMIT -- cgit v1.2.3