[fuy]

there's also things like pg_repack which don't lock the tables (but will incur high IO while freeing up the space).