Home Explore Blog CI



postgresql

2nd chunk of `doc/src/sgml/ref/reindexdb.sgml`
bbce057623a0e79e1aa6c95a90f8695d6e389d7387c9ac7a0000000100000fa0
 <literal>CONCURRENTLY</literal> option.  See
        <xref linkend="sql-reindex"/>, where all the caveats of this option
        are explained in detail.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option><optional>-d</optional> <replaceable class="parameter">dbname</replaceable></option></term>
      <term><option><optional>--dbname=</optional><replaceable class="parameter">dbname</replaceable></option></term>
      <listitem>
       <para>
        Specifies the name of the database to be reindexed,
        when <option>-a</option>/<option>--all</option> is not used.
        If this is not specified, the database name is read
        from the environment variable <envar>PGDATABASE</envar>.  If
        that is not set, the user name specified for the connection is
        used.  The <replaceable>dbname</replaceable> can be a <link
        linkend="libpq-connstring">connection string</link>.  If so,
        connection string parameters will override any conflicting command
        line options.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-e</option></term>
      <term><option>--echo</option></term>
      <listitem>
       <para>
        Echo the commands that <application>reindexdb</application> generates
        and sends to the server.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-i <replaceable class="parameter">index</replaceable></option></term>
      <term><option>--index=<replaceable class="parameter">index</replaceable></option></term>
      <listitem>
       <para>
        Recreate <replaceable class="parameter">index</replaceable> only.
        Multiple indexes can be recreated by writing multiple
        <option>-i</option> switches.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-j <replaceable class="parameter">njobs</replaceable></option></term>
      <term><option>--jobs=<replaceable class="parameter">njobs</replaceable></option></term>
      <listitem>
       <para>
        Execute the reindex commands in parallel by running
        <replaceable class="parameter">njobs</replaceable>
        commands simultaneously.  This option may reduce the processing time
        but it also increases the load on the database server.
       </para>
       <para>
        <application>reindexdb</application> will open
        <replaceable class="parameter">njobs</replaceable> connections to the
        database, so make sure your <xref linkend="guc-max-connections"/>
        setting is high enough to accommodate all connections.
       </para>
       <para>
        Note that this option is incompatible with the <option>--system</option> option.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-q</option></term>
      <term><option>--quiet</option></term>
      <listitem>
       <para>
        Do not display progress messages.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-s</option></term>
      <term><option>--system</option></term>
      <listitem>
       <para>
        Reindex database's system catalogs only.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-S <replaceable class="parameter">schema</replaceable></option></term>
      <term><option>--schema=<replaceable class="parameter">schema</replaceable></option></term>
      <listitem>
       <para>
        Reindex <replaceable class="parameter">schema</replaceable> only.
        Multiple schemas can be reindexed by writing multiple
        <option>-S</option> switches.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-t <replaceable class="parameter">table</replaceable></option></term>
      <term><option>--table=<replaceable class="parameter">table</replaceable></option></term>
      <listitem>
 

Title: reindexdb Options (Continued)
Summary
This section details additional command-line options for reindexdb. These options include echoing commands, specifying individual indexes to reindex, executing reindex commands in parallel using multiple jobs, suppressing progress messages, reindexing only system catalogs, specifying schemas to reindex, and more.