/usr/bin/pg_repack

pg_repack re-organizes a PostgreSQL database.

Usage:
  pg_repack [OPTION]... [DBNAME]
Options:
  -a, --all                          repack all databases
  -t, --table=TABLE                  repack specific table only
  -I, --parent-table=TABLE           repack specific parent table and its inheritors
  -c, --schema=SCHEMA                repack tables in specific schema only
  -s, --tablespace=TBLSPC            move repacked tables to a new tablespace
  -S, --moveidx                      move repacked indexes to TBLSPC too
  -o, --order-by=COLUMNS             order by columns instead of cluster keys
  -n, --no-order                     do vacuum full instead of cluster
  -N, --dry-run                      print what would have been repacked
  -j, --jobs=NUM                     Use this many parallel jobs for each table
  -i, --index=INDEX                  move only the specified index
  -x, --only-indexes                 move only indexes of the specified table
  -T, --wait-timeout=SECS            timeout to cancel other backends on conflict
  -D, --no-kill-backend              don't kill other backends when timed out
  -Z, --no-analyze                   don't analyze at end
  -k, --no-superuser-check           skip superuser checks in client
  -C, --exclude-extension            don't repack tables which belong to specific extension
      --no-error-on-invalid-index    repack even though invalid index is found
      --error-on-invalid-index       don't repack when invalid index is found, deprecated, as this is the default behavior now
      --apply-count                  number of tuples to apply in one transaction during replay
      --switch-threshold             switch tables when that many tuples are left to catchup

Connection options:
  -d, --dbname=DBNAME       database to connect
  -h, --host=HOSTNAME       database server host or socket directory
  -p, --port=PORT           database server port
  -U, --username=USERNAME   user name to connect as
  -w, --no-password         never prompt for password
  -W, --password            force password prompt

Generic options:
  -e, --echo                echo queries
  -E, --elevel=LEVEL        set output message level
  --help                    show this help, then exit
  --version                 output version information, then exit

Read the website for details: <https://reorg.github.io/pg_repack/>.
Report bugs to <https://github.com/reorg/pg_repack/issues>.