Re: many schemas or many databases

Hi

2011/2/8 Thomas Markus <t(dot)markus(at)proventis(dot)net>:
> hi,
>
> i would prefer many schemas. advantages:
> - one backup/restore for all (or selective)
> - one connection pool
> - simple access to all schemas
>

+1

and one disadvantage

- impossible separation on independent hw, when it is necessary or
when you has more hw

Depends on application and size of data - if you has lot of logs, or
some like OLAP data, then is very practical use more than one
database.

Regards

Pavel Stehule

> 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
>>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>