From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: ankush upadhyay <ankush.upadhyay@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Are there some additional postgres tuning to improve performance in multi tenant system
Date: Sat, 28 Dec 2013 22:54:14 +1300
Message-ID: <52BE9FC6.4060105@catalyst.net.nz> (raw)
In-Reply-To: <CAEzmm+aPueugN7VO+B_9dc0Oqrk1GJWv7RJ6SC_wdquzbfsQvw@mail.gmail.com>
References: <CAEzmm+aPueugN7VO+B_9dc0Oqrk1GJWv7RJ6SC_wdquzbfsQvw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz, ankush.upadhyay@gmail.com
Subject: Re: Are there some additional postgres tuning to improve performance in multi tenant system
In-Reply-To: <52BE9FC6.4060105@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox