Trying to delete large number of records from table, keeps timing out
I currently have a database table with 86M+ records. Many of these records are no longer needed; the data is no longer relevant, and I believe it is causing edge functions to time out because it is having trouble filtering through the data.
I am trying to delete these records, but everything I've tried times out. I've tried:
- Filtering in the table view and selecting all rows to delete
- Using the AI assistant to help me create an SQL query that will index the data, and then use another query to delete
- Migrating the data to be deleted to another table
With each of these options, I am getting time-out errors. How can I safely remove these records without running into the timeout errors?
Environment details: iOS, web (Chrome), @supabase/supabase-js@2.38.4
I am trying to delete these records, but everything I've tried times out. I've tried:
- Filtering in the table view and selecting all rows to delete
- Using the AI assistant to help me create an SQL query that will index the data, and then use another query to delete
- Migrating the data to be deleted to another table
With each of these options, I am getting time-out errors. How can I safely remove these records without running into the timeout errors?
Environment details: iOS, web (Chrome), @supabase/supabase-js@2.38.4
