From: | Thomas Markus <t(dot)markus(at)proventis(dot)net> |
---|---|
To: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: many schemas or many databases |
Date: | 2011-02-08 09:16:34 |
Message-ID: | 4D5109F2.8000701@proventis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi,
i would prefer many schemas. advantages:
- one backup/restore for all (or selective)
- one connection pool
- simple access to all schemas
regards
thomas
Am 08.02.2011 09:30, schrieb Szymon Guz:
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Itagaki Takahiro | 2011-02-08 09:22:18 | Re: [HACKERS] Issues with generate_series using integer boundaries |
Previous Message | Nicklas Avén | 2011-02-08 09:15:06 | Re: <>(not equal to) in where clause can use index |