Skip site navigation (1) Skip section navigation (2)

OT - how to size/match multiple databases/apps for a single server

From: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: OT - how to size/match multiple databases/apps for a single server
Date: 2006-11-29 18:03:03
Message-ID: 200611291103.03410.kevin@kevinkempterllc.com (view raw or flat)
Thread:
Lists: pgsql-performance
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...

pgsql-performance by date

Next:From: Ron MayerDate: 2006-11-29 18:47:00
Subject: Re: RES: Priority to a mission critical transaction
Previous:From: Brian HurtDate: 2006-11-29 17:21:31
Subject: Re: RES: Priority to a mission critical transaction

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group