[pietherr]

You shard for load distribution. If data isolation is #1 priority, use separate tables, schemas, database instances.

[zepolen]

Separate disks, separate machines hell even separate networks, proper data isolation can be super expensive to do right.