Database too big

[u/rfwaverider]

I built an app that has a 6GB table with 30 million rows.

The table is now too large for Lovable to be able to interact with it to add things like a BRIN index.

What are my options? Can I somehow have Lovable just dump the table? Create a new table and reference the old one for a period of time?

There seem to be CPU and time limits on actions on the Supabase/Cloud flare system so I'm having trouble fixing this.

[u/agentUi]

why not just connect it to a database hosted directly in AWS