| От | Rick Schumeyer |
|---|---|
| Тема | Multiple customers sharing one database? |
| Дата | |
| Msg-id | 46606523.7090202@ieee.org обсуждение |
| Ответы |
Re: Multiple customers sharing one database?
|
| Список | pgsql-general |
I'm developing an application that will be used by several independent customers. Conceptually, the data from one customer has no relation at all to another customer. In fact, each customer's data is private, and you would never combine data from different customers. I'm trying to decide whether to: a) give each customer a separate database or b) put everyone in the same database, but take steps to ensure that customer #1 cannot see data from customer #2. I was talking to an Oracle expert who suggested (based on his oracle background) option b where each customer has their own schema. His feeling was that each database has significant memory overhead, which then gets multiplied with option a. At least it does with oracle. Does anyone have any suggestions?
В списке pgsql-general по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера