From: | ow <oneway_111(at)yahoo(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Are we losing momentum? |
Date: | 2003-04-15 21:58:24 |
Message-ID: | 20030415215824.44241.qmail@web21404.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general pgsql-hackers pgsql-patches |
--- Neil Conway <neilc(at)samurai(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2003-04-15 22:12:10 | Re: Tech Docs and Consultants |
Previous Message | Michael Paesold | 2003-04-15 21:51:00 | Re: Are we losing momentum? |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-04-15 22:02:12 | Re: OT: mail server blocked |
Previous Message | Michael Paesold | 2003-04-15 21:51:00 | Re: Are we losing momentum? |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-04-15 22:04:17 | Re: Does libpq have SSL functions? |
Previous Message | Michael Paesold | 2003-04-15 21:51:00 | Re: Are we losing momentum? |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2003-04-15 22:33:18 | Re: the build |
Previous Message | Michael Paesold | 2003-04-15 21:51:00 | Re: Are we losing momentum? |