My app is used by about 80k users every month. I want to create separate PostgreSQL schemas for each user (a-la SaaS, for protection).
My app allows users to search other user's profiles, via:
SELECT user_id FROM user_table WHERE city = 'NYC';
What is the correct way to implement the same search functionality with unique schemas in place for each user?
Will performance suffer?