@@ -117,6 +117,7 @@ The following options can be specified in ``OPTIONS``.
117
117
Options:
118
118
-a, --all repack all databases
119
119
-t, --table=TABLE repack specific table only
120
+ -c, --schema=SCHEMA repack specific schema only
120
121
-s, --tablespace=TBLSPC move repacked tables to a new tablespace
121
122
-S, --moveidx move repacked indexes to *TBLSPC * too
122
123
-o, --order-by=COLUMNS order by columns instead of cluster keys
@@ -154,6 +155,11 @@ Reorg Options
154
155
reorganized by writing multiple ``-t `` switches. By default, all eligible
155
156
tables in the target databases are reorganized.
156
157
158
+ ``-c ``, ``--schema ``
159
+ Repack the specified schema(s) only. Multiple schemas may be repacked
160
+ by writing multiple ``-c `` switches. May be used in conjunction with
161
+ ``--tablespace `` to move tables and indexes to a different tablespace.
162
+
157
163
``-o COLUMNS [,...] ``, ``--order-by=COLUMNS [,...] ``
158
164
Perform an online CLUSTER ordered by the specified columns.
159
165
@@ -443,6 +449,7 @@ Releases
443
449
* Bugfix: correctly handle key indexes with options such as DESC, NULL
444
450
FIRST/LAST, COLLATE (pg_repack issue #3).
445
451
* More helpful program output and error messages.
452
+ * Added ``--schema `` to repack only specific schema.
446
453
447
454
* pg_repack 1.1.8
448
455
0 commit comments