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.[1] http://reorg.github.io/pg_repack/