BSD Ports

databases/pg_repack 1.5.2 DragonFly

Reorganize tables in PostgreSQL databases with minimal locks

System
DragonFly
Repository
DPorts
Maintainer
[email protected] (as in FreeBSD)
License
BSD3CLAUSE
Categories
databases
Package size
48.9 KiB, 138.0 KiB installed

Description

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.

In the other systems

SystemPortVersion
DragonFlydatabases/pg_repack1.5.2
FreeBSDdatabases/pg_repack1.5.3
NetBSDdatabases/pg_repack1.5.3

Install

Binary package:

pkg install postgresql16-pg_repack

From DPorts:

cd /usr/dports/databases/pg_repack && make install clean

Dependencies

Run dependencies 2

No port depends on this one.