How Postgres DELETE can actually scale

What happened

A detailed explanation of Postgres deletions and how to avoid poor deletion and garbage collection performance.

Summary assembled by rule from the sources below

Sources