Supabase considers sharding the best approach for scaling OLTP databases to petabyte sizes and recommends treating analytics separately.

“Eventually, that will slow down your database. So we think that sharding is by far the best way to do scale up into the petabytes, and then you should treat your analytics differently.”