Skip to content

Instantly share code, notes, and snippets.

@wilmoore

wilmoore/readme.md Secret

Last active April 3, 2025 17:27
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save wilmoore/2c80e4bca991714a17f5617f3c6e4159 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save wilmoore/2c80e4bca991714a17f5617f3c6e4159 to your computer and use it in GitHub Desktop.
Download ZIP
Software Engineering :: Database :: PostgreSQL :: Extension :: pg_repack
Raw
readme.md

Software Engineering :: Database :: PostgreSQL :: Extension :: pg_repack

⪼ Made with 💜 by Polyglot.

sources

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment