Post

Postgres -- Extensions (Draft)

pg_repack

What locks used

https://github.com/reorg/pg_repack/blob/306b0d4f7f86e807498ac00baec89ecd33411398/bin/pg_repack.c#L1599

How to clean up things

1
DROP EXTENSION IF EXISTS pg_repack CASCADE;

CASCADE will drop the repack schema, so all temporary tables, sequences, indices will all be dropped.

This post is licensed under CC BY 4.0 by the author.