Blogmark

For example, doing a full vacuum rewrites a table. This is why tools like pg_repack exist, which help reduce the amount of locking.

See the post for the full table of operations.