Re: Multiple DB join

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Multiple DB join
Date: 2006-08-15 11:38:32
Message-ID: 20060815113832.GA99592@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jorge Godoy 2006-08-15 12:01:03 Re: Multiple DB join
Previous Message Andrew Sullivan 2006-08-15 10:36:24 Re: Multiple DB join