From: ow <oneway_111@yahoo.com>
To: pgsql-hackers@postgresql.org
Subject: Re: Are we losing momentum?
Date: Tue, 15 Apr 2003 14:58:24 -0700 (PDT)
Message-ID: <20030415215824.44241.qmail@web21404.mail.yahoo.com> (raw)
In-Reply-To: <1050438427.368.37.camel@tokyo>
--- Neil Conway <neilc@samurai.com> wrote:
> Are you talking about queries between databases on the same
> postmaster
> (i.e. running under the same PostgreSQL installation),
Yes
> or queries
> between postmasters running on different systems? If the former, I
> don't
> see how putting your data into multiple schemas in a single database
> is
> significantly less reliable than putting it into multiple databases.
I disagree. For example, suppose you have
app12 that uses db1 and db2,
app23 that uses db2 and db3,
app3 that uses db3.
If db3 goes down then app12 is not affected, app23 could be partially
affected (e.g. user may not be able to run historic queries) and app3
is completely unavailable. This is definitely better than all three
apps are down. Besides, having one huge db makes everything more
difficult and requires (much) more time for backups, restores, etc.
Every major RDBMS vendor (and mySql) finds this feature important and
they support it. Hope Postgresql will too.
__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com
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-hackers@postgresql.org
Cc: oneway_111@yahoo.com
Subject: Re: Are we losing momentum?
In-Reply-To: <20030415215824.44241.qmail@web21404.mail.yahoo.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