Re: multi-tenant vs. multi-cluster - Mailing list pgsql-general

From Ivan Voras
Subject Re: multi-tenant vs. multi-cluster
Date
Msg-id im09bo$s5r$1@dough.gmane.org
Whole thread Raw
In response to multi-tenant vs. multi-cluster  (Ben Chobot <bench@silentmedia.com>)
Responses Re: multi-tenant vs. multi-cluster  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
On 18/03/2011 19:17, Ben Chobot wrote:

> if we're talking an extra 50MB of memory per cluster, that will start to add up.

Consider this: each such cluster will have:

a) its own database files on the drives (WAL, data - increasing IO)
b) its own postgresql processes (many of them) running in memory
c) its own shared_buffers in memory.

It is highly unlikely that you will manage anything decent with this
type of configuration with a non-trivial number of clusters.

pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: multi-tenant vs. multi-cluster
Next
From: Ben Chobot
Date:
Subject: Re: multi-tenant vs. multi-cluster