Projects / pg_repack

pg_repack

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, with performance comparable to using CLUSTER directly.

Tags
Licenses
Implementation

Recent releases

  •  19 May 2014 12:08

    Release Notes: This release offers several improvements and bugfixes to the previous pg_reorg/pg_repack release 1.1.8. It adds the ability to move tables and indexes across tablespaces (online SET TABLESPACE); adds the ability to repack only the indexes of a table; has faster, parallel index operations; and has more friendly command line switches and error messages.

    Screenshot

    Project Spotlight

    OpenStack4j

    A Fluent OpenStack client API for Java.

    Screenshot

    Project Spotlight

    TurnKey TWiki Appliance

    A TWiki appliance that is easy to use and lightweight.