A big asterisk that should be added to the article is that all that applies to Postgres.

Other databases have their own deletion mechanisms (and deletion quirks)

It's a very good article otherwise.