pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: ow <oneway_111@yahoo.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Are we losing momentum?
Date: Tue, 15 Apr 2003 19:28:27 -0400
Message-ID: <10954.1050449307@sss.pgh.pa.us> (raw)
In-Reply-To: <20030415215824.44241.qmail@web21404.mail.yahoo.com>
References: <20030415215824.44241.qmail@web21404.mail.yahoo.com>

ow <oneway_111@yahoo.com> writes:
> --- Neil Conway <neilc@samurai.com> wrote:
>> Are you talking about queries between databases on the same
>> postmaster

> Yes

> [snip]

> 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 nonsense.  There is no scenario where one DB "goes down" and
other DBs on the same postmaster remain up.  There are advantages to
having separate DBs on one postmaster (like separate copies of the
system catalogs), but there's very little reliability differential
compared to a multi-schema approach.

			regards, tom lane




view thread (140+ messages)  latest in thread

Message-ID: <10954.1050449307@sss.pgh.pa.us>
Permalink:  ../10954.1050449307@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/10954.1050449307@sss.pgh.pa.us

 · 

reply

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: tgl@sss.pgh.pa.us, oneway_111@yahoo.com
  Subject: Re: Are we losing momentum?
  In-Reply-To: <10954.1050449307@sss.pgh.pa.us>

* 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