pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
Message-ID: <200611291103.03410.kevin@kevinkempterllc.com> (raw)

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...



Message-ID: <200611291103.03410.kevin@kevinkempterllc.com>
Permalink:  ../200611291103.03410.kevin@kevinkempterllc.com/
Also on:    postgresql.org/message-id/200611291103.03410.kevin@kevinkempterllc.com

 · 

reply

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: kevin@kevinkempterllc.com
  Subject: Re: OT - how to size/match multiple databases/apps for a single server
  In-Reply-To: <200611291103.03410.kevin@kevinkempterllc.com>

* 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