At my current workplace, we deal with this via postgres schema per tenant. We have a script that ensures every schema has the same tables, indices and permissions. Scales pretty well.

I just wish postgres on AWS had better ability to separate compute and storage.