aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/vacuumlo.sgml26
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>