Revision history [back]

The method for utilizing the pg_repack extension with Azure PostgreSQL is as follows:

1. Connect to your Azure PostgreSQL database using psql or another client tool.
2. Verify that you have superuser privileges on the database.
3. Install the pg_repack extension using the following command:

CREATE EXTENSION pg_repack;

1. Once the extension is installed, you can use the following command to repack a table:

SELECT pg_repack('schema.tablename');

Replace "schema.tablename" with the name of the table you want to repack. This command will repack the table, which reclaims space and ensures that the table is organized in the most efficient way possible.

Note: It's important to monitor the progress of the repack operation, as it can take some time and may impact the performance of your database.