Foreign Key Cascade Deletes: Un-Indexed FKs, Slow Cascades, and Lock Contention in PostgreSQL

Running a DELETE on a parent entity with ON DELETE CASCADE feels like clean relational cleanup. But...