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

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: ankush upadhyay <ankush(dot)upadhyay(at)gmail(dot)com>, 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 09:54:14
Message-ID: 52BE9FC6.4060105@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ankush upadhyay 2013-12-28 11:40:54 Re: Are there some additional postgres tuning to improve performance in multi tenant system
Previous Message ankush upadhyay 2013-12-28 05:19:01 Are there some additional postgres tuning to improve performance in multi tenant system