X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C05404758F1 for ; Tue, 15 Apr 2003 19:28:25 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id F0356474E44 for ; Tue, 15 Apr 2003 19:28:24 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h3FNSRU6010955; Tue, 15 Apr 2003 19:28:27 -0400 (EDT) To: ow Cc: pgsql-hackers@postgresql.org Subject: Re: Are we losing momentum? In-reply-to: <20030415215824.44241.qmail@web21404.mail.yahoo.com> References: <20030415215824.44241.qmail@web21404.mail.yahoo.com> Comments: In-reply-to ow message dated "Tue, 15 Apr 2003 14:58:24 -0700" Date: Tue, 15 Apr 2003 19:28:27 -0400 Message-ID: <10954.1050449307@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.3 required=5.0 tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/544 X-Sequence-Number: 38034 ow writes: > --- Neil Conway 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