> It is far from a premature optimization IMO, it is super useful and something > I was hoping would happen ever since I heard about transition tables being > worked on.
Me too. Never-ending DELETEs are a common pain point especially for people migrated from MySQL which creates indexes for foreign keys automatically.