From: | ankush upadhyay <ankush(dot)upadhyay(at)gmail(dot)com> |
---|---|
To: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Are there some additional postgres tuning to improve performance in multi tenant system |
Date: | 2013-12-28 11:40:54 |
Message-ID: | CAEzmm+abGLh0_YPF1QT4B4yk-vBaP3pv-sxarX-j2m2sHX+DSA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)kirkwood(at)catalyst(dot)net(dot)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@
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2013-12-28 13:20:07 | Re: Are there some additional postgres tuning to improve performance in multi tenant system |
Previous Message | Mark Kirkwood | 2013-12-28 09:54:14 | Re: Are there some additional postgres tuning to improve performance in multi tenant system |