pg_repack is a PostgreSQL extension that allows you to efficiently reorganize a table In order to get rid of table bloat that it has accumulated. Do note that the table reorganization may take some time but pg_repack tries to minimize the locks it takes in order to allow for online operations

In order to use the extension pg_repack: (run as avnadmin)

CREATE EXTENSION pg_repack;

Followed by the running of the commandline tool that comes with the extension on your own machine. The command to reorganize a single table looks like:

pg_repack -d connstr --no-superuser-check  -t tablename

Which will result in the table called tablename being reorganized.

Did this answer your question?