Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP
Reorganize tables in PostgreSQL databases with minimal locks
C Makefile

Fetching latest commit…

Cannot retrieve the latest commit at this time

Failed to load latest commit information.
SPECS
bin
doc
lib
msvc
.gitignore
COPYRIGHT
META.json
Makefile
README.rst

README.rst

pg_repack -- 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.

Please check the documentation (in the doc directory or online) for installation and usage instructions.

What about pg_reorg?

pg_repack is a fork of the pg_reorg project, which has proven hugely successful. Unfortunately the last version of pg_reorg was 1.1.7, released in Aug. 2011, and development of the project has stagnated since then. The first release of pg_repack contains many key improvements which have been missing from pg_reorg (e.g. support for PostgreSQL 9.2, and EXTENSION packaging).

In an effort to make the transition for existing pg_reorg users simple, and facilitate a possible merge back with pg_reorg, we are releasing pg_repack 1.1.8 as a drop-in replacement for pg_reorg, addressing the pg_reorg 1.1.7 bugs and shortcomings. We are also developing new features to be released in an upcoming 1.2 version. pg_repack may be an interim solution, should the pg_reorg project come back to life.

In the meantime, we thank the original pg_reorg authors for the quality code they have released to the community, wish them good luck, and hope to collaborate further in the future.

Something went wrong with that request. Please try again.