No instance size and pay for what you use. So you could have 10gb or 10tb and only pay scale you’re indexes up or down with out having to pay for an allocation of RAM
The biggest issue is network latency and costs if it had to jump between clouds for every database call. My GCP managed postgres are pretty cheap compared to the other stuff.