Blogmark
PostgreSQL Operations that can cause Table Rewrites
via jbranchaud@gmail.com
https://www.linkedin.com/posts/gwenshapira_table-rewrites-can-be-slow-and-disruptive-activity-7322327616135319552-ipFR
PostgreSQL
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.