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.
Got here by accident? Learn how Aiven simplifies Postgres: