From: Kevin Kempter <kevin@kevinkempterllc.com>
To: pgsql-performance@postgresql.org
Subject: OT - how to size/match multiple databases/apps for a single server
Date: Wed, 29 Nov 2006 11:03:03 -0700
User-Agent: KMail/1.9.5
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200611291103.03410.kevin@kevinkempterllc.com>

Hi List;

I have a client looking to host/co-locate multiple PostgreSQL clusters 
(inclusive of PL/pgSQL application code) per server. I did some co-location 
work several years back with one of the bigger telco's and remember there 
were dire consequences for not carefully evaluating the expected resource 
usage of each database/app and matching apps based on some common sense (i.e. 
match a memory intensive app with a CPU intensive app)

My question is:
Does anyone have any templates, guidelines, thoughts, etc with respect to how 
to eval and match multiple databases for a single server. Such as a checklist 
of resource items to look at and guidelines per how to line up db clusters 
that should play nicely together?

Thanks in advance...