Re: advantages of multiple db's

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

From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Little, Douglas
Sent: Thursday, October 28, 2010 8:35 AM
To: pgsql-admin(at)postgresql(dot)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(dot)Little(at)orbitz(dot)com<mailto:Douglas(dot)Little(at)orbitz(dot)com>
[cid:image001(dot)jpg(at)01CB767B(dot)49473710] orbitz.com<http://www.orbitz.com/> | ebookers.com<http://www.ebookers.com/> | hotelclub.com<http://www.hotelclub.com/> | cheaptickets.com<http://www.cheaptickets.com/> | ratestogo.com<http://www.ratestogo.com/> | asiahotels.com<http://www.asiahotels.com/>