Schema per user?
От | Anders Steinlein |
---|---|
Тема | Schema per user? |
Дата | |
Msg-id | FC231040-97F0-42B5-970E-C1AA0F5ED2A6@steinlein.no обсуждение исходный текст |
Ответы |
Re: Schema per user?
Re: Schema per user? Re: Schema per user? |
Список | pgsql-general |
Hi, I'm pondering a design question for a subscription-based web-app we are developing. Would it be feasible to create a new schema per user account, setting the search_path to their own schema during login? There is no shared data (except where we keep a record of users), as each account is entirely self-contained. I would usually just put username into relevant tables and querying based on this, but I figured separate schemas *might* have a few advantages: Ease scaling by placing users across different tablespaces and/or databases, easier backup/restore of specific user's data and no vacuum when we delete accounts (just drop schema vs delete). Has anyone done something like this, or is it simply A Bad Idea? How many schemas can a database contain, until one hits a (hard or soft) limit? Keep in mind that this is not a "regular" web-app with thousands of users, but more in the range of 500-1000 for the foreseeable future. Regads, Anders
В списке pgsql-general по дате отправления: