X-Original-To: pgsql-hackers@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DDDFB476302 for ; Tue, 15 Apr 2003 16:28:26 -0400 (EDT) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by postgresql.org (Postfix) with ESMTP id 6841D4758F1 for ; Tue, 15 Apr 2003 16:28:24 -0400 (EDT) Received: from DU150.N224.ResNet.QueensU.CA (DU150.N224.ResNet.QueensU.CA [130.15.224.150]) by bob.samurai.com (Postfix) with ESMTP id 5390C1F12; Tue, 15 Apr 2003 16:27:48 -0400 (EDT) Subject: Re: Are we losing momentum? From: Neil Conway To: ow Cc: PostgreSQL Hackers , Tom Lane In-Reply-To: <20030415193518.14217.qmail@web21414.mail.yahoo.com> References: <20030415193518.14217.qmail@web21414.mail.yahoo.com> Content-Type: text/plain Organization: Message-Id: <1050438427.368.37.camel@tokyo> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 15 Apr 2003 16:27:07 -0400 Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_XIMIAN 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/524 X-Sequence-Number: 38014 On Tue, 2003-04-15 at 15:35, ow wrote: > Some databases contain lots of data, e.g. dbs that contain historical > data. No one wants to have one HUGE db that runs all company's apps, > takes hours (if not days) to recover and when this huge db goes down > none of the apps is available. Are you talking about queries between databases on the same postmaster (i.e. running under the same PostgreSQL installation), 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. Cheers, Neil