Re: Multiple DB join - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Multiple DB join
Date
Msg-id 20060815113832.GA99592@winnie.fuhr.org
Whole thread Raw
In response to Re: Multiple DB join  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: Multiple DB join  (Jorge Godoy <jgodoy@gmail.com>)
List pgsql-sql
On Tue, Aug 15, 2006 at 06:36:24AM -0400, Andrew Sullivan wrote:
> On Mon, Aug 14, 2006 at 05:26:10PM -0400, Sumeet Ambre wrote:
> > I have a database which consists of 20 million records and I've split up 
> > the db into 6-7 dbs. 
> 
> You can do this (as someone suggested with dblink), but I'm wondering
> why the split?  20 million records isn't very big.

And why multiple databases instead of multiple schemas within the
same database?  Or even all data in the same schema?  Is there a
reason for the segregation?

-- 
Michael Fuhr


pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Multiple DB join
Next
From: Jorge Godoy
Date:
Subject: Re: Multiple DB join