≈ the.bay.news

Deleting one user row empties 21 of our 29 tables, and the delete statement names one of them

DEV Community
Deleting one user row empties 21 of our 29 tables, and the delete statement names one of them
29 tables in one Drizzle file, 311 columns, no enum type and no varchar anywhere, 36 CHECK constraints doing that job, and 30 foreign keys of which 26 cascade. What a single DELETE actually reaches, and the two referencing columns Postgres has to scan to do it.

0 comments

Sign in to join the discussion — your thebay.events account works here.

No comments yet.