pg_reorg
- pg_reorg
is a PostgreSQL utility to reorganize tables.
pg_reorg allows you to reorganize your tables online, for example, you could perform an online VACUUM FULL, or CLUSTER.
pg_reorg can re-organize tables without any locks, and can be a better alternative of CLUSTER, and VACUUM FULL.
Installation
-
Using the FreeBSD ports
system:
cd /usr/ports/databases/pg_reorg make install clean
Using the FreeBSD pkg system:pkg install databases/pg_reorg
Documentation
- For the full documentation, please see: http://pgreorg.sourceforge.net/pg_reorg.html