pg_repack
reorganize tables in PostgreSQL databases with minimal locks
Install
- All systems
-
curl cmd.cat/pg_repack.sh
- Debian
-
apt-get install postgresql-11-repack - Ubuntu
-
apt-get install postgresql-11-repack - Kali Linux
-
apt-get install postgresql-11-repack - Windows (WSL2)
-
sudo apt-get updatesudo apt-get install postgresql-11-repack - Raspbian
-
apt-get install postgresql-9.6-repack - Dockerfile
- dockerfile.run/pg_repack
postgresql-11-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. This package contains the pg_repack program and the server extension for PostgreSQL 11.
postgresql-9.6-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. This package contains the pg_repack program and the server extension for PostgreSQL 9.6.