diff options
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/vacuumlo.sgml | 26 |
1 files changed, 15 insertions, 11 deletions
diff --git a/doc/src/sgml/vacuumlo.sgml b/doc/src/sgml/vacuumlo.sgml index 0ae39c71d2c..97753de6c0c 100644 --- a/doc/src/sgml/vacuumlo.sgml +++ b/doc/src/sgml/vacuumlo.sgml @@ -50,19 +50,22 @@ vacuumlo [options] database [database2 ... databaseN] </varlistentry> <varlistentry> - <term><option>-U</option> <replaceable>username</></term> + <term><option>-l</option> <replaceable>limit</></term> <listitem> - <para>User name to connect as.</para> + <para> + Remove no more than <replaceable>limit</> large objects per + transaction (default 1000). Since the server acquires a lock per LO + removed, removing too many LOs in one transaction risks exceeding + <xref linkend="guc-max-locks-per-transaction">. Set the limit to + zero if you want all removals done in a single transaction. + </para> </listitem> </varlistentry> <varlistentry> - <term><option>-l</option> <replaceable>limit</></term> + <term><option>-U</option> <replaceable>username</></term> <listitem> - <para> - Stop after removing LIMIT large objects. Useful to avoid - exceeding <xref linkend="guc-max-locks-per-transaction">. - </para> + <para>User name to connect as.</para> </listitem> </varlistentry> @@ -120,18 +123,19 @@ vacuumlo [options] database [database2 ... databaseN] <title>Method</title> <para> - First, it builds a temporary table which contains all of the OIDs of the - large objects in that database. + First, <application>vacuumlo</> builds a temporary table which contains all + of the OIDs of the large objects in the selected database. </para> <para> It then scans through all columns in the database that are of type <type>oid</> or <type>lo</>, and removes matching entries from the - temporary table. + temporary table. (Note: only types with these names are considered; + in particular, domains over them are not considered.) </para> <para> - The remaining entries in the temp table identify orphaned LOs. + The remaining entries in the temporary table identify orphaned LOs. These are removed. </para> </sect2> |