<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/vacuumdb.sgml,v 1.48 2010/01/0712:38:55 momjian Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/vacuumdb.sgml,v 1.49 2010/01/0714:35:44 momjian Exp $

PostgreSQL documentation

-->

<group><arg>--freeze</arg><arg>-F</arg></group>

<group><arg>--verbose</arg><arg>-v</arg></group>

<group><arg>--analyze</arg><arg>-z</arg></group>

<group><arg>--analyze-only</arg><arg>-o</arg></group>

<group><arg>--analyze-only</arg><arg>-Z</arg></group>

<arg>--table | -t <replaceable>table</replaceable>

<arg>( <replaceable class="parameter">column</replaceable> [,...] )</arg>

</arg>

<group><arg>--freeze</arg><arg>-F</arg></group>

<group><arg>--verbose</arg><arg>-v</arg></group>

<group><arg>--analyze</arg><arg>-z</arg></group>

<group><arg>--analyze-only</arg><arg>-o</arg></group>

<group><arg>--analyze-only</arg><arg>-Z</arg></group>

</cmdsynopsis>

</refsynopsisdiv>

</varlistentry>

<varlistentry>

<term><option>-o</option></term>

<term><option>-Z</option></term>

<term><option>--analyze-only</option></term>

<listitem>

<para>

{"quiet",no_argument,NULL,'q'},

{"dbname",required_argument,NULL,'d'},

{"analyze",no_argument,NULL,'z'},

{"analyze-only",no_argument,NULL,'o'},

{"analyze-only",no_argument,NULL,'Z'},

{"freeze",no_argument,NULL,'F'},

{"all",no_argument,NULL,'a'},

{"table",required_argument,NULL,'t'},

case'z':

and_analyze= true;

break;

case'o':

case'Z':

analyze_only= true;

break;

case'F':

printf(_(" -f, --full do full vacuuming\n"));

printf(_(" -F, --freeze freeze row transaction information\n"));

printf(_(" -i, --inplace do full inplace vacuuming\n"));

printf(_(" -o, --analyze-only only update optimizer hints\n"));

printf(_(" -q, --quiet don't write any messages\n"));

printf(_(" -t, --table='TABLE[(COLUMNS)]' vacuum specific table only\n"));

printf(_(" -v, --verbose write a lot of output\n"));

printf(_(" -z, --analyze update optimizer hints\n"));

printf(_(" -Z, --analyze-only only update optimizer hints\n"));

printf(_(" --help show this help, then exit\n"));

printf(_(" --version output version information, then exit\n"));

printf(_("\nConnection options:\n"));