I can say that we helped a customer migrate a DB of over 1 TB over from RDS to Supabase. Feel free to contact us if you have any questions.
Is there anything approximating a hard limit at the moment (AWS Aurora is at 128TB at the moment). Do you do anything with Citus or CockroachDB or normal partitioning behind the scenes?