many schemas or many databases

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: many schemas or many databases
Date: 2011-02-08 08:30:05
Message-ID: AANLkTim3GiPneGZB_mMacEBpHdT+J8FODTptXpNoqh+V@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
is there any noticeable difference between a cluster with many databases and
a database with many schemas?

I've got a quite huge database on Oracle with about 400 logically disjoint
schemas.
I could import that into PostgreSQL as many different databases, or as one
database with many schemas.

From the application point of view it could be easier to have different
databases, as for now the applications log in into different schemas, so
this behavior wouldn't change.

Do you see any drawbacks of any of the solutions?

regards
Szymon

Responses

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2011-02-08 09:09:01 <>(not equal to) in where clause can use index
Previous Message Niklas Langvig 2011-02-08 08:01:38 Question about database configuration