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