Conversation

query planning: 200μs
query execution: 400ms
deletion cascading: 20 minutes

someone who is good in this economy please help me budget this. my DB is dying.

1
0
4

the solution: an index

1
0
2

@charlotte

I don't know about other databases, but PostgreSQL does not automatically create an index for columns containing a foreign key, so yeah, deletes in the foreign table will be slow if you don't create the appropriate indices.

0
0
0