Postgres Pro
Downloads
Home   >   mailing lists

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

From Sergey Konoplev
Subject Re: advantages of multiple db's
Date
Msg-id AANLkTikw4nFmgB8fmvdbxvgWrQcXkPN=-ADdmy5UhSVp@mail.gmail.com
Whole thread Raw
In response to advantages of multiple db's  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
List pgsql-admin
Tree view
HI,

On 28 October 2010 17:34, Little, Douglas <DOUGLAS.LITTLE@orbitz.com> wrote:

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?


I think this article is a good start point to find the answer on this questions http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
 

 

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

 




--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp
Attachment

pgsql-admin by date:

Previous
From: "Plugge, Joe R."
Date:
Subject: Re: advantages of multiple db's
Next
From: Kieren Scott
Date:
Subject: Re: Using LDAP with postgresql 8.2