diff options
| author | Simon Riggs <simon@2ndQuadrant.com> | 2014-12-09 00:28:00 +0900 |
|---|---|---|
| committer | Simon Riggs <simon@2ndQuadrant.com> | 2014-12-09 00:28:00 +0900 |
| commit | fe263d115a7dd16095b8b8f1e943aff2bb4574d2 (patch) | |
| tree | 2aad301f83277d605f7b87a0a2f91957fbe5771e /doc/src | |
| parent | 8001fe67a3d66c95861ce1f7075ef03953670d13 (diff) | |
| download | postgresql-fe263d115a7dd16095b8b8f1e943aff2bb4574d2.tar.gz postgresql-fe263d115a7dd16095b8b8f1e943aff2bb4574d2.zip | |
REINDEX SCHEMA
Add new SCHEMA option to REINDEX and reindexdb.
Sawada Masahiko
Reviewed by Michael Paquier and FabrÃzio de Royes Mello
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/reindex.sgml | 15 | ||||
| -rw-r--r-- | doc/src/sgml/ref/reindexdb.sgml | 22 |
2 files changed, 36 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index cabae191bc7..0a4c7d45cbf 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -21,7 +21,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> -REINDEX { INDEX | TABLE | DATABASE | SYSTEM } <replaceable class="PARAMETER">name</replaceable> [ FORCE ] +REINDEX { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } <replaceable class="PARAMETER">name</replaceable> [ FORCE ] </synopsis> </refsynopsisdiv> @@ -101,6 +101,19 @@ REINDEX { INDEX | TABLE | DATABASE | SYSTEM } <replaceable class="PARAMETER">nam </varlistentry> <varlistentry> + <term><literal>SCHEMA</literal></term> + <listitem> + <para> + Recreate all indexes of the specified schema. If a table of this + schema has a secondary <quote>TOAST</> table, that is reindexed as + well. Indexes on shared system catalogs are also processed. + This form of <command>REINDEX</command> cannot be executed inside a + transaction block. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>DATABASE</literal></term> <listitem> <para> diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index 486f5c9367a..b5b449c256f 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -27,6 +27,16 @@ PostgreSQL documentation <arg choice="plain" rep="repeat"> <arg choice="opt"> <group choice="plain"> + <arg choice="plain"><option>--schema</option></arg> + <arg choice="plain"><option>-S</option></arg> + </group> + <replaceable>table</replaceable> + </arg> + </arg> + + <arg choice="plain" rep="repeat"> + <arg choice="opt"> + <group choice="plain"> <arg choice="plain"><option>--table</option></arg> <arg choice="plain"><option>-t</option></arg> </group> @@ -162,6 +172,18 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>-S <replaceable class="parameter">schema</replaceable></></term> + <term><option>--schema=<replaceable class="parameter">schema</replaceable></></term> + <listitem> + <para> + Reindex <replaceable class="parameter">schema</replaceable> only. + Multiple schemas can be reindexed by writing multiple + <option>-S</> switches. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-t <replaceable class="parameter">table</replaceable></></term> <term><option>--table=<replaceable class="parameter">table</replaceable></></term> <listitem> |