It’s a good approach, but one of the big perks of the apartment approach with schema per tenant is total separation of indexes across all tables in addition to just the isolation aspect. The approach of schema per tenant also makes it a lot easier for you to scale horizontally by tenant, or even breaking things into entirely regionalized zones. When the tenant doesn’t need access to other tenant info it’s a big perk.
You don’t necessarily need Apartment to do it, but the approach has a lot of benefits.
