Re: [PERFORM] Are there some additional postgres tuning to improve performance in multi tenant system
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
Re: [PERFORM] Are there some additional postgres tuning to improve performance in multi tenant system
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.kirkw...@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: [PERFORM] Are there some additional postgres tuning to improve performance in multi tenant system
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
Re: [PERFORM] Are there some additional postgres tuning to improve performance in multi tenant system
On Sat, Dec 28, 2013 at 6:50 PM, Andrew Dunstan and...@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: [PERFORM] Are there some additional postgres tuning to improve performance in multi tenant system
On 12/28/2013 08:46 AM, ankush upadhyay wrote: On Sat, Dec 28, 2013 at 6:50 PM, Andrew Dunstan and...@dunslane.net mailto:and...@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
[PERFORM] Are there some additional postgres tuning to improve performance in multi tenant system
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@