From: Dan Harris <fbsd@drivefaster.net>
To: PostgreSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Is it possible to start two instances of postgresql?
Date: Thu, 15 Jun 2006 11:17:25 -0600
Message-ID: <44919625.8040200@drivefaster.net> (raw)
In-Reply-To: <44911706.60204@superlativ.dk>
References: <OFF8F23C1E.A2D18557-ON4825718E.0027A8DA@pengroup.com.my>
<44911706.60204@superlativ.dk>
> kah_hang_ang@toray.com.my wrote:
>
>
>> both of the two database are live but use for two different web app.
>> my company don't want to spend more to buy a new server, so then I think of
>> to implement both under the same server and one instance..
Just as an anecdote, I am running 30 databases on a single instance and
it's working quite well. There may be reasons to run multiple
instances but it seems like tuning them to cooperate for memory would
pose some problems - e.g. effective_cache_size.
-Dan
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: fbsd@drivefaster.net
Subject: Re: Is it possible to start two instances of postgresql?
In-Reply-To: <44919625.8040200@drivefaster.net>
* 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