Re: Are there some additional postgres tuning to improve performance in multi tenant system

Поиск
Список
Период
Сортировка
От ankush upadhyay
Тема Re: Are there some additional postgres tuning to improve performance in multi tenant system
Дата
Msg-id CAEzmm+abGLh0_YPF1QT4B4yk-vBaP3pv-sxarX-j2m2sHX+DSA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Are there some additional postgres tuning to improve performance in multi tenant system  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-performance
Дерево обсуждения
I am using multiple databases in my app for multi tenacy environment.

In my app user login with tenant id and connect to respective database.

The scenario is when 5 users connect to 5 databases and perform some activity in that case site performance going down and some time database server become unresponsive.

In each database we have same schema with different data regarding to users of that tenant.
Any idea?


On Sat, Dec 28, 2013 at 3:24 PM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:
On 28/12/13 18:19, ankush upadhyay wrote:
Hello All,

I am using multi tenant system and doing performance testing of multi
tenant application. In case of single tenant it is working fine but once
I enable tenants, then some time database servers not responding. Any clue?


It is a bit tricky to tell without any relevant information (e.g schema description). But a likely culprit would be a missing index on the relevant 'tenant_id' type field in each table that you are using to distinguish the various tenant datasets.

Regards

Mark



--
------
Regards
@Ankush Upadhyay@

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Are there some additional postgres tuning to improve performance in multi tenant system
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Are there some additional postgres tuning to improve performance in multi tenant system