pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guido Neitzer <guido.neitzer@pharmaline.de>
To: Michael Fuhr <mike@fuhr.org>
Cc: slackman@unika.ac.id
Cc: pgsql-admin@postgresql.org
Subject: Re: which is the best
Date: Mon, 17 Apr 2006 12:00:27 +0200
Message-ID: <EE91AA35-AE6E-47C7-B4DF-5E2140E3DBB8@pharmaline.de> (raw)
In-Reply-To: <20060417031801.GA37181@winnie.fuhr.org>
References: <20060417024259.12090.qmail@mail.unika.ac.id>
	<20060417031801.GA37181@winnie.fuhr.org>

On 17.04.2006, at 5:18 Uhr, Michael Fuhr wrote:

> 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.

This is also dependant on the tool you use for accessing the  
databases. E.g. Apple WebObjects has no problems in working with  
relationships over severals databases, even if these databases are  
from different vendors. I have an application running, that joins  
information from a PostgreSQL, a FrontBase and an Oracle db in one  
"fetch" without any special voodoo going on on the database side.  
Only thing to have is that primary and foreign keys are in a  
compatible format.

I think this question can't be answered correctly without specific  
knowledge about the whole environment.

cug

-- 
PharmaLine, Essen, GERMANY
Software and Database Development

Attachments:

  smime.p7s (application/pkcs7-signature, 2.4K) download

view thread (4+ messages)  latest in thread

Message-ID: <EE91AA35-AE6E-47C7-B4DF-5E2140E3DBB8@pharmaline.de>
Permalink:  ../EE91AA35-AE6E-47C7-B4DF-5E2140E3DBB8@pharmaline.de/
Also on:    postgresql.org/message-id/EE91AA35-AE6E-47C7-B4DF-5E2140E3DBB8@pharmaline.de

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: guido.neitzer@pharmaline.de, mike@fuhr.org, slackman@unika.ac.id
  Subject: Re: which is the best
  In-Reply-To: <EE91AA35-AE6E-47C7-B4DF-5E2140E3DBB8@pharmaline.de>
  References: <20060417024259.12090.qmail@mail.unika.ac.id> <20060417031801.GA37181@winnie.fuhr.org> <EE91AA35-AE6E-47C7-B4DF-5E2140E3DBB8@pharmaline.de>

* 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