Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
ankush upadhyay
Date:
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? 

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

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

From
Mark Kirkwood
Date:
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

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

From
ankush upadhyay
Date:
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@

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

From
Andrew Dunstan
Date:
On 12/28/2013 12:19 AM, 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?
>
>



I usually use the term "multi-tenancy" to refer to different postgres
instances running on the same machine, rather than different databases
within a single instance of postgres. So lease describe your setup in
more detail.

cheers

andrew

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

From
ankush upadhyay
Date:
On Sat, Dec 28, 2013 at 6:50 PM, Andrew Dunstan <andrew@dunslane.net> wrote:

On 12/28/2013 12:19 AM, 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?





I usually use the term "multi-tenancy" to refer to different postgres instances running on the same machine, rather than different databases within a single instance of postgres. So lease describe your setup in more detail.

cheers

andrew


First of all Thanks Andrew for let me know email etiquette and extremely sorry for confusion.

Here I meant to say that  different postgres instances running on the same machine.

Actually I have one application machine and one database server machine with multiple postgres instances running on it and accessing by application server.

I hope this time I could explain it in more details.

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

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

From
Andrew Dunstan
Date:
On 12/28/2013 08:46 AM, ankush upadhyay wrote:
> On Sat, Dec 28, 2013 at 6:50 PM, Andrew Dunstan <andrew@dunslane.net
> <mailto:andrew@dunslane.net>> wrote:
>
>
>     On 12/28/2013 12:19 AM, 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?
>
>
>
>
>
>     I usually use the term "multi-tenancy" to refer to different
>     postgres instances running on the same machine, rather than
>     different databases within a single instance of postgres. So lease
>     describe your setup in more detail.
>
>     cheers
>
>     andrew
>
>
>
> First of all Thanks Andrew for let me know email etiquette and
> extremely sorry for confusion.
>
> Here I meant to say that  different postgres instances running on the
> same machine.
>
> Actually I have one application machine and one database server
> machine with multiple postgres instances running on it and accessing
> by application server.
>
> I hope this time I could explain it in more details.
>
>


Why are you doing that, as opposed to running multiple databases in a
single instance? Running more than a handful of instances in a single
machine is almost always a recipe for poor performance. The vast
majority of users in my experience run a single postgres instance per
machine, possibly with a large number of databases.

cheers

andrew