@@ -117,10 +117,10 @@ The following options can be specified in ``OPTIONS``.
117
117
118
118
Options:
119
119
-a, --all repack all databases
120
- -j, --jobs Use this many parallel jobs for each table
121
- -n, --no-order do vacuum full instead of cluster
122
- -o, --order-by=COLUMNS order by columns instead of cluster keys
123
120
-t, --table=TABLE repack specific table only
121
+ -o, --order-by=COLUMNS order by columns instead of cluster keys
122
+ -n, --no-order do vacuum full instead of cluster
123
+ -j, --jobs Use this many parallel jobs for each table
124
124
-T, --wait-timeout=SECS timeout to cancel other backends on conflict
125
125
-Z, --no-analyze don't analyze at end
126
126
@@ -142,25 +142,26 @@ Generic options:
142
142
Reorg Options
143
143
^^^^^^^^^^^^^
144
144
145
- Options to order rows. If not specified, pg_repack performs an online CLUSTER
146
- using cluster indexes. Only one option can be specified. You may also specify
147
- target tables or databases.
148
-
149
- ``-j ``, ``--jobs ``
150
- Create the specified number of extra connections to PostgreSQL, and
151
- use these extra connections to parallelize the rebuild of indexes
152
- on each table. If your PostgreSQL server has extra cores and disk
153
- I/O available, this can be a useful way to speed up pg_repack.
145
+ ``-a ``, ``--all ``
146
+ Attempt repack all the databases of the cluster. Databases where the
147
+ ``pg_repack `` extension is not installed will be skipped.
154
148
155
- ``-n ``, ``--no-order ``
156
- Perform an online VACUUM FULL.
149
+ ``-t TABLE ``, ``--table=TABLE ``
150
+ Reorganize the specified table only. By default, all eligible tables in
151
+ the target databases are reorganized.
157
152
158
153
``-o COLUMNS [,...] ``, ``--order-by=COLUMNS [,...] ``
159
154
Perform an online CLUSTER ordered by the specified columns.
160
155
161
- ``-t TABLE ``, ``--table=TABLE ``
162
- Reorganize the specified table only. By default, all eligible tables in
163
- the target databases are reorganized.
156
+ ``-n ``, ``--no-order ``
157
+ Perform an online VACUUM FULL. Since version 1.2 this is the default for
158
+ non-clustered tables.
159
+
160
+ ``-j ``, ``--jobs ``
161
+ Create the specified number of extra connections to PostgreSQL, and
162
+ use these extra connections to parallelize the rebuild of indexes
163
+ on each table. If your PostgreSQL server has extra cores and disk
164
+ I/O available, this can be a useful way to speed up pg_repack.
164
165
165
166
``-T SECS ``, ``--wait-timeout=SECS ``
166
167
pg_repack needs to take an exclusive lock at the end of the
@@ -175,6 +176,7 @@ target tables or databases.
175
176
Disable ANALYZE after the reorganization. If not specified, run ANALYZE
176
177
after the reorganization.
177
178
179
+
178
180
Connection Options
179
181
^^^^^^^^^^^^^^^^^^
180
182
0 commit comments