reorg/pg_repack
View on GitHub ↗ ★ 2,326 C
Reorganize tables in PostgreSQL databases with minimal locks
7 mentions on Hacker News by 7 people: 1 story, 6 comments · first 2013-01-18 · latest 2026-06-15
20082026
-
…until those dead tuples are handled. I have used a very similar strategy by forking repack client https://github.com/reorg/pg_repack/pull/326 This works out of the box with rds/cloudsql etc.
comment by ankitml · 2026-06-15 · in The only scalable delete in Postgres is DROP TABLE -
…space. It has saved me so much space. 1: https://ossc-db.github.io/pg_bulkload/pg_bulkload.html 2: https://github.com/reorg/pg_repack
comment by bitbasher · 2025-07-05 · in Speeding up PostgreSQL dump/restore snapshots -
there's an extension called `pg_repack` ( https://github.com/reorg/pg_repack ) that already did this as a third-party solution. It even goes a bit farther in that it doesn't just rebuild indexes but can also rewrite a table completely in…
comment by pilif · 2019-05-23 · in PostgreSQL 12 Beta 1 Released -
…a chance to use it myself yet, but it's designed for reclaiming bloated space without downtime. [1] https://github.com/reorg/pg_repack/
comment by felixge · 2018-03-06 · in A new storage engine for PostgreSQL to provide better control over bloat -
▲ 4
Reorganize tables in PostgreSQL databases with minimal locksstory by renlinx · 2015-12-01 · 0 comments
-
You can do online clustering with pg_repack ( https://github.com/reorg/pg_repack ). Given a table T, it will: 1. Create a new empty table T'. 2. Add a trigger on T that will clone any operations to T'. 3. Copy all rows from T to T' in…
comment by atombender · 2013-03-02 · in Postgres: The Bits You Haven't Found -
…VACUUM FULL. This project is not active now, and fork project "pg_repack" takes over its role. See https://github.com/reorg/pg_repack for details.
comment by mixmastamyk · 2013-01-18 · in Handling Growth with Postgres