Szymon Guz, 08.02.2011 09:30:
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
Il 08/02/2011 10.42, Pavel Stehule ha scritto:
> Hi
>
> 2011/2/8 Thomas Markus :
>> hi,
>>
>> i would prefer many schemas. advantages:
>> - one backup/restore for all (or selective)
But this also means if one crashes all crash.
And lack of flexibility in deployments.
It heavily depends in what
Hi
2011/2/8 Thomas Markus :
> 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
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 wit
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.
