Postgres Pro
Downloads
Home   >   mailing lists

Re: advantages of multiple db's - Mailing list pgsql-admin

From Plugge, Joe R.
Subject Re: advantages of multiple db's
Date
Msg-id BD69807DAE0CE44CA00A8338D0FDD08302E8F07007@oma00cexmbx03.corp.westworlds.com
Whole thread Raw
In response to advantages of multiple db's  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
List pgsql-admin
Tree view

Postgres does not natively do cross joins, you can however use a third party tool called dblink

 

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Little, Douglas
Sent: Thursday, October 28, 2010 8:35 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] advantages of multiple db's

 

Hi,

 

We have 1 db with everything in our entire enterprise in it (It’s a data warehouse).  What are some of the disadvantages of using multiple db’s?

 

Can we join across db’s?

 

Doug Little

 

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 

Attachment

pgsql-admin by date:

Previous
From: "Little, Douglas"
Date:
Subject: advantages of multiple db's
Next
From: Sergey Konoplev
Date:
Subject: Re: advantages of multiple db's