How Postgres DELETE can actually scale

Automated excerpt

When you delete a row in Postgres, the database doesn’t physically delete the row. When you delete a row, Postgres stamps its final version with your transaction ID, making the row invisible to later transactions. To delete a row, Postgres stamps it with the transaction ID of the transaction that deleted it.

Selected automatically from source text; not independently written or fact-checked. Read the original for full context.