[bastawhiz]

If you're creating one Postgres index per user, you're going to have a bad time really fast.

[sroussey]

Would eat up inodes? Not sure how these work, does it create separate files for each one?

[rco8786]

Index per tenant but yes, if you have hundreds or thousands of tenants that becomes a more difficult problem to manage but not at all unmanageable.