Re: which is the best

On Mon, Apr 17, 2006 at 09:42:59AM +0700, slackman(at)unika(dot)ac(dot)id wrote:
> Now I have 3 database A,B,C is working in Interbase v 5.6,
> but Interbas v 5.6 is no longger can hold what the client wants,
> I will conver it in Postgresql, I need your advice which is the
> bertter result:
>
> (1):
> unika (schema)
> |
> |------ A
> |------------ B
> |------------------- C
>
> (2) create database A, create database B, create database C

Which way is "better" depends on your access patterns. PostgreSQL
doesn't support cross-database queries (except via functions like
dblink), so if you need to join tables in one database with tables
in another then you'll probably want make A, B, and C schemas in
the same database. But if A, B, and C have no relationship with
one another then you might want to isolate them as separate databases.

--
Michael Fuhr