Firebase is a service that encompasses a bunch of things.

Do you mean Cloud Firestore?

To be clear, when I reference the infinite scalability, I mean the ability of cloud functions to spin up as many instances as I need.

In terms of database load, I'd fully expect to have to migrate to a larger instance, but that is also relatively easy with cloud sql postgres.

Cloud Firestore how does that relate to Datastore? Really wish Google would allow multi-region Cloud SQL like AWS allows with RDS. Datastore is such a pain to use with its index requirements

Firestore is the next generation: https://cloud.google.com/datastore/docs/firestore-or-datasto...

Ah yeah, I was mostly talking about the database offerings. The cloud functions can scale infinitely.

Cloud Firestore scales just fine, like any database, you have to know how to work with it. You switched from a nosql database to a sql database... two totally different performance profiles.