Re: Experience with many schemas vs many databases

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Experience with many schemas vs many databases
Дата
Msg-id 4AFFC4FA.3000007@hogranch.com
обсуждение исходный текст
Ответ на Experience with many schemas vs many databases  (undisclosed user <lovetodrinkpepsi@gmail.com>)
Список pgsql-general
undisclosed user wrote:
> Hello everyone,
>
> I have hit a wall on completing a solution I am working on.
> Originally, the app used a db per user (on MyIsam)....the solution did
> not fair so well in reliability and performance. I have been
> increasingly interested in Postgres lately.
>
> Currently, I have about 30-35k users/databases. The general table
> layout is the same....only the data is different. I don't need to
> share data across databases. Very similar to a multi-tenant design.

35000 users with separate databases isn't going to scale well on ANY
conventional system I'm familiar with


В списке pgsql-general по дате отправления:

Предыдущее
От: undisclosed user
Дата:
Сообщение: Experience with many schemas vs many databases
Следующее
От: Jorge Godoy
Дата:
Сообщение: Re: Experience with many schemas vs many databases