From: Andrew Dunstan <andrew@dunslane.net>
To: ankush upadhyay <ankush.upadhyay@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Are there some additional postgres tuning to improve performance in multi tenant system
Date: Sat, 28 Dec 2013 08:54:03 -0500
Message-ID: <52BED7FB.6020602@dunslane.net> (raw)
In-Reply-To: <CAEzmm+Zs53QPjyKRuN+hkYtE3NZ1tW45YJN=p_1j=vQJSgN+TQ@mail.gmail.com>
References: <CAEzmm+aPueugN7VO+B_9dc0Oqrk1GJWv7RJ6SC_wdquzbfsQvw@mail.gmail.com>
<52BED007.2050304@dunslane.net>
<CAEzmm+Zs53QPjyKRuN+hkYtE3NZ1tW45YJN=p_1j=vQJSgN+TQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
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: andrew@dunslane.net, ankush.upadhyay@gmail.com
Subject: Re: Are there some additional postgres tuning to improve performance in multi tenant system
In-Reply-To: <52BED7FB.6020602@dunslane.net>
* 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