gurjeet on Speedup of deletes on PostgreSQL · Hackerly

Comment on Speedup of deletes on PostgreSQL parent

This is not true. Even OP says so

... foreign keys are not indexed by default.