Re: 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 <andrew(at)dunslane(dot)net
> <mailto:andrew(at)dunslane(dot)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