PostgreSQL Locking Revealed
Tangential: does anybody know how dependable is pg_repack[1]? I just discovered it and the promise is  great - being able to do a VACUUM FULL, and even move tables around, without locking them and thus without downtime - but I'm not sure what are the risks in using it in production.<p>[1] <a href="http://reorg.github.io/pg_repack/" rel="nofollow">http://reorg.github.io/pg_repack/</a>