hundreds of schema vs hundreds of databases - Mailing list pgsql-general

From olivier
Subject hundreds of schema vs hundreds of databases
Date
Msg-id f3f5df$2oj5$1@news.hub.org
Whole thread Raw
List pgsql-general
Hi group,

I have an application with some hundreds users, each one having the same
data definitions, and each one storing up to 2 GB of data.
A user have just access to his own data. His data will have its own
tablespace.

Therefore, it seems to me I have a choice between "one database per
user" and "one schema per user in the same database".

What is the best practice here ? Which solution will be the easiest to
manage ?


Cheers,

   Olivier





pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: How to create trigger if it does not exist
Next
From: Lew
Date:
Subject: Re: Delete with subquery deleting all records