diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/pg_restore.sgml | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml index 1a23874da68..2e3ba802581 100644 --- a/doc/src/sgml/ref/pg_restore.sgml +++ b/doc/src/sgml/ref/pg_restore.sgml @@ -787,6 +787,30 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>--transaction-size=<replaceable class="parameter">N</replaceable></option></term> + <listitem> + <para> + Execute the restore as a series of transactions, each processing + up to <replaceable class="parameter">N</replaceable> database + objects. This option implies <option>--exit-on-error</option>. + </para> + <para> + <option>--transaction-size</option> offers an intermediate choice + between the default behavior (one transaction per SQL command) + and <option>-1</option>/<option>--single-transaction</option> + (one transaction for all restored objects). + While <option>--single-transaction</option> has the least + overhead, it may be impractical for large databases because the + transaction will take a lock on each restored object, possibly + exhausting the server's lock table space. + Using <option>--transaction-size</option> with a size of a few + thousand objects offers nearly the same performance benefits while + capping the amount of lock table space needed. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>--use-set-session-authorization</option></term> <listitem> <para> |