From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Andreas Philipp <andreas.philipp@clinicauniversitariateleton.edu.co>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Advice on running two database clusters on one server machine
Date: Wed, 18 Jun 2008 14:49:14 -0500
Message-ID: <4859202A.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <dcc563d10806161943g39a65285q5cd9b8ba5d4a04ce@mail.gmail.com>
References: <72fa1b080806151011h357edc5bm92af30e08aeefd61@mail.gmail.com>
<dcc563d10806161943g39a65285q5cd9b8ba5d4a04ce@mail.gmail.com>
>>> "Scott Marlowe" <scott.marlowe@gmail.com> wrote:
> Andreas Philipp <andreas.philipp@clinicauniversitariateleton.edu.co>
wrote:
>> We are wondering about the advisability to distribute the databases
between
>> the two server machines, both machines acting as active production
systems
>> for one application each, and as warm standby servers for the other,
using
>> WAL shipping to a second database cluster running on another port on
each of
>> the two server machines.
>>
>> What would be the performance cost of doing so, rather than running
all
>> databases on one database cluster on one machine, and using the
second
>> machine as a warm standby server for all databases of the two
applications?
>
> Well, when both machines are working, your performance would be
better
> on two machines than on one. But after a failover, the warm standby
> will be running two instances of postgresql, and that's sub-optimal.
We have many machines here running multiple PostgreSQL clusters,
including one running two clusters, each with hundreds of GB of data,
which run tens of millions of queries per day without performance
problems. (It's also running several Java processes through which all
this traffic passes.) It is a matter of having adequate hardware,
properly tuned databases, efficient software design, and well written
queries.
-Kevin
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-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, andreas.philipp@clinicauniversitariateleton.edu.co, scott.marlowe@gmail.com
Subject: Re: Advice on running two database clusters on one server machine
In-Reply-To: <4859202A.EE98.0025.0@wicourts.gov>
* 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