Re: hundreds of schema vs hundreds of databases

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: hundreds of schema vs hundreds of databases
Date: 2007-05-29 17:59:00
Message-ID: 465C69E4.9040503@burntmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Albe Laurenz wrote:
>
> Advantages of many databases:
> - Each database is smaller.
> - No danger of one user accessing another user's data (because of
> misconfigured permissions and similar).
> - Guaranteed independence of each user's data.
> - More scalable: If you decide that one machine or one cluster
> is not enough to handle the load, you can easily transfer some
> of the databases somewhere else.
>
> Advantages of one database with many schemata:
> - Fewer databases to administrate.

Using different databases for each user incurs the full overhead of
creating and maintaining a database: all the system tables and all the
memory required to keep a database open. If the OP is allowing direct
SQL access to each user, then the risks you identify above must be
addressed, but tbey can fairly simply by using scripts to create each
new user. I'd opt for using schemas unless there is a compelling
evidence that different databases are required.

--
Guy Rouillier

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-29 17:59:02 Re: Best way to prevent overlapping dates
Previous Message Joshua 2007-05-29 17:46:45 Re: problems with SELECT query results