Lists: | pgsql-general |
---|
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 |
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
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 |
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: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Thomas Markus <t(dot)markus(at)proventis(dot)net> |
Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: many schemas or many databases |
Date: | 2011-02-08 09:42:46 |
Message-ID: | AANLkTi=2fXzDE1KuenuJKuFM06z=QjMzwxvtsmKrecfz@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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
>
From: | Ivano Luberti <luberti(at)archicoop(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: many schemas or many databases |
Date: | 2011-02-08 19:41:50 |
Message-ID: | 4D519C7E.3010505@archicoop.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Il 08/02/2011 10.42, Pavel Stehule ha scritto:
> 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)
But this also means if one crashes all crash.
And lack of flexibility in deployments.
It heavily depends in what grade of independence you want among the
applications.
--
==================================================
dott. Ivano Mario Luberti
Archimede Informatica societa' cooperativa a r. l.
Sede Operativa
Via Gereschi 36 - 56126- Pisa
tel.: +39-050- 580959
tel/fax: +39-050-9711344
web: www.archicoop.it
==================================================
From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: many schemas or many databases |
Date: | 2011-02-08 21:34:08 |
Message-ID: | iiscsh$a5$1@dough.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
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 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?
>
I think the question is: do you have queries that retrieve data from different schemas in Oracle?
If so then the only way to go in PostgreSQL is to use multiple schemas.
If you don't need cross-schema/database queries then I don't think there is none of the solution is particular better than the other. Both have advantages and disadvantages (as described by the other posters)
Regards
Thomas