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.

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:


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 which will result in the table called tablename being reorganized.

pg_repack -d connstr --no-superuser-check  -t tablename
Did this answer your question?