diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-01-03 06:26:22 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-01-03 06:26:22 +0000 |
| commit | bc29b06b0aaa2ed1d1117af03918697694135314 (patch) | |
| tree | 84ece15a3ba9c4bfaedf49694598ddc3220dadec /doc/src | |
| parent | a4ee277e175a0965fcd2d61f06c85ac9ee0617ac (diff) | |
| download | postgresql-bc29b06b0aaa2ed1d1117af03918697694135314.tar.gz postgresql-bc29b06b0aaa2ed1d1117af03918697694135314.zip | |
Add mention of index on foreign key for frequently updated primary key
tables.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index ec264dbb118..87ebda032ef 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.50 2001/12/08 03:24:35 thomas Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.51 2002/01/03 06:26:22 momjian Exp $ PostgreSQL documentation --> @@ -437,6 +437,13 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: </varlistentry> </variablelist> </para> + <para> + If primary key column is updated frequently, it may be wise to + add an index to the <literal>REFERENCES</literal> column so that + <literal>NO ACTION</literal> and <literal>CASCADE</literal> + actions associated with the <literal>REFERENCES</literal> + column can be more efficiently performed. + </para> </listitem> </varlistentry> @@ -472,6 +479,8 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: </listitem> </varlistentry> </variablelist> + + </refsect1> |