Skip to content

Commit b6bd078

Browse files
committed
Added documentation for --tablespace and --moveidx
1 parent d98a14b commit b6bd078

File tree

1 file changed

+16
-0
lines changed

1 file changed

+16
-0
lines changed

doc/pg_repack.rst

Lines changed: 16 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -121,6 +121,8 @@ Options:
121121
-n, --no-order do vacuum full instead of cluster
122122
-o, --order-by=COLUMNS order by columns instead of cluster keys
123123
-t, --table=TABLE repack specific table only
124+
-s, --tablespace=TABLESPC move repacked tables to a new tablespace
125+
-S, --moveidx move repacked indexes to TABLESPC too
124126
-T, --wait-timeout=SECS timeout to cancel other backends on conflict
125127
-Z, --no-analyze don't analyze at end
126128

@@ -162,6 +164,15 @@ target tables or databases.
162164
Reorganize the specified table only. By default, all eligible tables in
163165
the target databases are reorganized.
164166

167+
``-s TABLESPC``, ``--tablespace=TABLESPC``
168+
Move the repacked tables to the specified tablespace: essentially an
169+
online version of ``ALTER TABLE ... SET TABLESPACE``. The tables indexes
170+
are left on the original tablespace unless ``--moveidx`` is specified too.
171+
172+
``-S``, ``--moveidx``
173+
Move the indexes too of the repacked tables to the tablespace specified
174+
by the option ``--tablespace``.
175+
165176
``-T SECS``, ``--wait-timeout=SECS``
166177
pg_repack needs to take an exclusive lock at the end of the
167178
reorganization. This setting controls how many seconds pg_repack will
@@ -175,6 +186,7 @@ target tables or databases.
175186
Disable ANALYZE after the reorganization. If not specified, run ANALYZE
176187
after the reorganization.
177188

189+
178190
Connection Options
179191
^^^^^^^^^^^^^^^^^^
180192

@@ -399,6 +411,10 @@ and the original one.
399411
Releases
400412
--------
401413

414+
* pg_repack 1.2
415+
416+
* Added --tablespace and --moveidx options to perform online SET TABLESPACE.
417+
402418
* pg_repack 1.1.8
403419

404420
* Added support for PostgreSQL 9.2.

0 commit comments

Comments
 (0)