X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id C8F6911F6379 for ; Mon, 17 Apr 2006 00:18:21 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.6 X-Spam-Level: X-Spam-Status: No, score=-2.6 required=5 tests=[BAYES_00=-2.599, SPF_PASS=-0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id Kr1iRgU9+kld for ; Mon, 17 Apr 2006 00:18:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by postgresql.org (Postfix) with ESMTP id 3F88C11F6325 for ; Mon, 17 Apr 2006 00:18:10 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id k3H3I3sT042498 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Sun, 16 Apr 2006 21:18:06 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.4/8.13.4) with ESMTP id k3H3I3LR037254; Sun, 16 Apr 2006 21:18:03 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.4/8.13.4/Submit) id k3H3I28u037253; Sun, 16 Apr 2006 21:18:02 -0600 (MDT) (envelope-from mfuhr) Date: Sun, 16 Apr 2006 21:18:01 -0600 From: Michael Fuhr To: slackman@unika.ac.id Cc: pgsql-admin@postgresql.org Subject: Re: which is the best Message-ID: <20060417031801.GA37181@winnie.fuhr.org> References: <20060417024259.12090.qmail@mail.unika.ac.id> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060417024259.12090.qmail@mail.unika.ac.id> X-Archive-Number: 200604/139 X-Sequence-Number: 21308 On Mon, Apr 17, 2006 at 09:42:59AM +0700, slackman@unika.ac.id wrote: > Now I have 3 database A,B,C is working in Interbase v 5.6, > but Interbas v 5.6 is no longger can hold what the client wants, > I will conver it in Postgresql, I need your advice which is the > bertter result: > > (1): > unika (schema) > | > |------ A > |------------ B > |------------------- C > > (2) create database A, create database B, create database C Which way is "better" depends on your access patterns. PostgreSQL doesn't support cross-database queries (except via functions like dblink), so if you need to join tables in one database with tables in another then you'll probably want make A, B, and C schemas in the same database. But if A, B, and C have no relationship with one another then you might want to isolate them as separate databases. -- Michael Fuhr