pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAre there some additional postgres tuning to improve performance in multi tenant system
6+ messages / 3 participants
[nested] [flat]
* Are there some additional postgres tuning to improve performance in multi tenant system
@ 2013-12-28 05:19 ankush upadhyay <ankush.upadhyay@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: ankush upadhyay @ 2013-12-28 05:19 UTC (permalink / raw)
To: pgsql-performance
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@
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Are there some additional postgres tuning to improve performance in multi tenant system
@ 2013-12-28 09:54 Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
parent: ankush upadhyay <ankush.upadhyay@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Mark Kirkwood @ 2013-12-28 09:54 UTC (permalink / raw)
To: ankush upadhyay <ankush.upadhyay@gmail.com>; 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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Are there some additional postgres tuning to improve performance in multi tenant system
@ 2013-12-28 11:40 ankush upadhyay <ankush.upadhyay@gmail.com>
parent: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
0 siblings, 0 replies; 6+ messages in thread
From: ankush upadhyay @ 2013-12-28 11:40 UTC (permalink / raw)
To: 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@
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Are there some additional postgres tuning to improve performance in multi tenant system
@ 2013-12-28 13:20 Andrew Dunstan <andrew@dunslane.net>
parent: ankush upadhyay <ankush.upadhyay@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Andrew Dunstan @ 2013-12-28 13:20 UTC (permalink / raw)
To: ankush upadhyay <ankush.upadhyay@gmail.com>; +Cc: pgsql-performance
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Are there some additional postgres tuning to improve performance in multi tenant system
@ 2013-12-28 13:46 ankush upadhyay <ankush.upadhyay@gmail.com>
parent: Andrew Dunstan <andrew@dunslane.net>
0 siblings, 1 reply; 6+ messages in thread
From: ankush upadhyay @ 2013-12-28 13:46 UTC (permalink / raw)
To: andrew@dunslane.net; pgsql-performance
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@
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Are there some additional postgres tuning to improve performance in multi tenant system
@ 2013-12-28 13:54 Andrew Dunstan <andrew@dunslane.net>
parent: ankush upadhyay <ankush.upadhyay@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Andrew Dunstan @ 2013-12-28 13:54 UTC (permalink / raw)
To: ankush upadhyay <ankush.upadhyay@gmail.com>; +Cc: pgsql-performance
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2013-12-28 13:54 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-12-28 05:19 Are there some additional postgres tuning to improve performance in multi tenant system ankush upadhyay <ankush.upadhyay@gmail.com>
2013-12-28 09:54 ` Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
2013-12-28 11:40 ` ankush upadhyay <ankush.upadhyay@gmail.com>
2013-12-28 13:20 ` Andrew Dunstan <andrew@dunslane.net>
2013-12-28 13:46 ` ankush upadhyay <ankush.upadhyay@gmail.com>
2013-12-28 13:54 ` Andrew Dunstan <andrew@dunslane.net>
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