From: Chris Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: Is it possible to start two instances of postgresql?
Date: Thu, 15 Jun 2006 11:01:51 -0400
Message-ID: <60mzcetqcg.fsf@dba2.int.libertyrms.com> (raw)
References: <OF22151056.C45B8022-ON4825718E.0019A675@pengroup.com.my>
kah_hang_ang@toray.com.my writes:
> Is it possible to start two instances of postgresql with different port and
> directory which run simultaneously?
Certainly. We have one HACMP cluster which hosts 14 PostgreSQL
instances across two physical boxes. (If one went down, they'd all
migrate to the survivor...)
> If can then will this cause any problem or performance drop down?
There certainly can be; the databases will be sharing disks, memory,
and CPUs, so if they are avidly competing for resources, the
competition is sure to have some impact on performance.
Flip side: That 14 database cluster has several databases that are
known to be very lightly used; they *aren't* competing, and aren't a
problem.
Consider it obvious that if you haven't enough memory or I/O bandwidth
to cover your two PG instances, you'll find performance sucks... If
you have enough, then it can work fine...
--
select 'cbbrowne' || '@' || 'acm.org';
http://cbbrowne.com/info/linuxxian.html
"At Microsoft, it doesn't matter which file you're compiling, only
which flags you #define." -- Colin Plumb
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: cbbrowne@acm.org
Subject: Re: Is it possible to start two instances of postgresql?
In-Reply-To: <60mzcetqcg.fsf@dba2.int.libertyrms.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