Reorganize tables in PostgreSQL databases with minimal locks
Pg_repack is a PostgreSQL extension which lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on the processed tables during processing. pg_repack is efficient to boot, with performance comparable to using CLUSTER directly.
$
pkg install postgresql17-pg_repackOrigin
databases/pg_repack
Size
141KiB
License
BSD3CLAUSE
Maintainer
farrokhi@FreeBSD.org
Dependencies
2 packages
Required by
0 packages