DELETEing a large number of rows from public.contact causes Supabase to timeout and the operation fails

chester-hill-solutions / callcaster

Outreach Software Solution

2 stars 0 forks source link

DELETEing a large number of rows from public.contact causes Supabase to timeout and the operation fails #676

Open manstephen opened 1 month ago

manstephen commented 1 month ago

I didn't rigorously test the threshold, but calling DELETE on 100 is okay while calling it on 6000 is not okay. From what I read on a stackoverflow: this could be due to the trigger function adding execution time to each DELETE call, which eventually exceeds the maximum time allowed by Supabase, but I'm not 100% sure.