Repository files navigation

• Homepage:http://reorg.github.com/pg_repack
• Download:http://pgxn.org/dist/pg_repack/
• Development:https://github.com/reorg/pg_repack
• Bug Report:https://github.com/reorg/pg_repack/issues
• Mailing List:http://pgfoundry.org/mailman/listinfo/reorg-general

pg_repack is a PostgreSQL extension which lets you remove bloat fromtables and indexes, and optionally restore the physical order of clusteredindexes. UnlikeCLUSTER andVACUUM FULL it works online, withoutholding an exclusive lock on the processed tables during processing.pg_repack is efficient to boot, with performance comparable to usingCLUSTER directly.

Please check the documentation (in thedoc directory oronline) forinstallation and usage instructions.

All users of pg_reorg 1.1.9 or earlier, and pg_repack 1.2.0-beta1 or earlier,areurged to upgrade to the latest pg_repack version to fix a seriousdata corruptionissue.

pg_repack is a fork of thepg_reorg project, which has proven hugelysuccessful. Unfortunately new feature development onpg_reorg has slowedor stopped since late 2011.

pg_repack was initially released as a drop-in replacement for pg_reorg,addressing some of the shortcomings of the last pg_reorg version (such assupport for PostgreSQL 9.2 and EXTENSION packaging) and known bugs.

pg_repack 1.2 introduces further new features (parallel index builds,ability to rebuild only indexes) and bugfixes. In some cases its behaviourmay be different from the 1.1.x release so it shouldn't be considered adrop-in replacement: you are advised to check thedocumentation beforeupgrading from previous versions.