Re: Experience with many schemas vs many databases

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Experience with many schemas vs many databases
Дата
Msg-id 4B006567.2040803@hogranch.com
обсуждение исходный текст
Ответ на Experience with many schemas vs many databases  (undisclosed user <lovetodrinkpepsi@gmail.com>)
Список pgsql-general
undisclosed user wrote:
> 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.

Do these users make their own arbitrary SQL queries?    Or is all the
coding canned, and they are simply running applications?   in the latter
case, I would definitely suggest using a single database and schema, and
one set of tables and having CustomerID be a field that you index in
these tables.







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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Experience with many schemas vs many databases
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Voting: "pg_ctl init" versus "initdb"