@@ -121,6 +121,8 @@ Options:
121
121
-n, --no-order do vacuum full instead of cluster
122
122
-o, --order-by=COLUMNS order by columns instead of cluster keys
123
123
-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
124
126
-T, --wait-timeout=SECS timeout to cancel other backends on conflict
125
127
-Z, --no-analyze don't analyze at end
126
128
@@ -162,6 +164,15 @@ target tables or databases.
162
164
Reorganize the specified table only. By default, all eligible tables in
163
165
the target databases are reorganized.
164
166
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
+
165
176
``-T SECS ``, ``--wait-timeout=SECS ``
166
177
pg_repack needs to take an exclusive lock at the end of the
167
178
reorganization. This setting controls how many seconds pg_repack will
@@ -175,6 +186,7 @@ target tables or databases.
175
186
Disable ANALYZE after the reorganization. If not specified, run ANALYZE
176
187
after the reorganization.
177
188
189
+
178
190
Connection Options
179
191
^^^^^^^^^^^^^^^^^^
180
192
@@ -399,6 +411,10 @@ and the original one.
399
411
Releases
400
412
--------
401
413
414
+ * pg_repack 1.2
415
+
416
+ * Added --tablespace and --moveidx options to perform online SET TABLESPACE.
417
+
402
418
* pg_repack 1.1.8
403
419
404
420
* Added support for PostgreSQL 9.2.
0 commit comments