Re: How PostgreSQL handles multiple DDBB instances?

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: How PostgreSQL handles multiple DDBB instances?
Дата
Msg-id 1180476453.26915.79.camel@dogma.v10.wvs
обсуждение исходный текст
Ответ на Re: How PostgreSQL handles multiple DDBB instances?  (Arnau <arnaulist@andromeiberica.com>)
Ответы Re: How PostgreSQL handles multiple DDBB instances?  (Craig James <craig_james@emolecules.com>)
Список pgsql-performance
On Fri, 2007-05-25 at 20:16 +0200, Arnau wrote:
>    The point I'm worried is performance. Do you think the performance
> would be better executing exactly the same queries only adding an extra
> column to all the tables e.g. customer_id, than open a connection to the
> only one customers DB and execute the query there?

Have you already considered using views with specific privileges to
separate your customers?

Regards,
    Jeff Davis


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

Предыдущее
От: "Luke Lonergan"
Дата:
Сообщение: Re: setting up raid10 with more than 4 drives
Следующее
От: "Tyrrill, Ed"
Дата:
Сообщение: Very slow left outer join