2012-11-15 11:39:51 +00:00
|
|
|
pg_repack -- Reorganize tables in PostgreSQL databases with minimal locks
|
|
|
|
|
=========================================================================
|
2012-09-22 11:30:32 +01:00
|
|
|
|
2012-11-11 02:38:09 +00:00
|
|
|
- Homepage: http://reorg.github.com/pg_repack
|
2012-11-15 15:36:44 +00:00
|
|
|
- Download: http://pgxn.org/dist/pg_repack/
|
2012-11-11 02:38:09 +00:00
|
|
|
- Development: https://github.com/reorg/pg_repack
|
2012-12-01 12:57:17 +00:00
|
|
|
- Bug Report: https://github.com/reorg/pg_repack/issues
|
2012-11-11 02:38:09 +00:00
|
|
|
- Mailing List: http://pgfoundry.org/mailman/listinfo/reorg-general
|
2012-09-22 11:30:32 +01:00
|
|
|
|
2017-03-25 22:52:40 +00:00
|
|
|
|travis|
|
|
|
|
|
|
|
|
|
|
.. |travis| image:: https://travis-ci.org/reorg/pg_repack.svg?branch=master
|
|
|
|
|
:target: https://travis-ci.org/reorg/pg_repack
|
|
|
|
|
:alt: Linux and OSX build status
|
|
|
|
|
|
2012-11-15 11:39:51 +00:00
|
|
|
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.
|
2012-09-22 11:30:32 +01:00
|
|
|
|
2012-11-12 12:44:13 +00:00
|
|
|
Please check the documentation (in the ``doc`` directory or online_) for
|
|
|
|
|
installation and usage instructions.
|
2012-09-22 11:30:32 +01:00
|
|
|
|
2012-11-11 02:38:09 +00:00
|
|
|
.. _pg_repack: http://reorg.github.com/pg_repack
|
2012-11-15 11:39:51 +00:00
|
|
|
.. _CLUSTER: http://www.postgresql.org/docs/current/static/sql-cluster.html
|
|
|
|
|
.. _VACUUM FULL: VACUUM_
|
|
|
|
|
.. _VACUUM: http://www.postgresql.org/docs/current/static/sql-vacuum.html
|
2012-11-12 12:44:13 +00:00
|
|
|
.. _online: pg_repack_
|
2014-05-22 23:36:06 -04:00
|
|
|
.. _issue: https://github.com/reorg/pg_repack/issues/23
|
2012-09-22 11:30:32 +01:00
|
|
|
|
2012-11-11 02:38:09 +00:00
|
|
|
|
2012-11-12 12:44:13 +00:00
|
|
|
What about pg_reorg?
|
|
|
|
|
--------------------
|
|
|
|
|
|
|
|
|
|
pg_repack is a fork of the pg_reorg_ project, which has proven hugely
|
2014-05-22 15:08:39 -04:00
|
|
|
successful. Unfortunately new feature development on pg_reorg_ has slowed
|
|
|
|
|
or 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 as
|
|
|
|
|
support 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 behaviour
|
|
|
|
|
may be different from the 1.1.x release so it shouldn't be considered a
|
|
|
|
|
drop-in replacement: you are advised to check the documentation__ before
|
|
|
|
|
upgrading from previous versions.
|
2013-11-05 01:38:47 +00:00
|
|
|
|
|
|
|
|
.. __: pg_repack_
|
2012-11-12 12:44:13 +00:00
|
|
|
.. _pg_reorg: http://reorg.projects.pgfoundry.org/
|
