Re: Help whit schemas - Mailing list pgsql-novice

From Sean Davis
Subject Re: Help whit schemas
Date
Msg-id 200702120719.32453.sdavis2@mail.nih.gov
Whole thread Raw
In response to Help whit schemas  ("Gustavo" <gustavor@intercomgi.net>)
List pgsql-novice
On Monday 12 February 2007 05:58, Gustavo wrote:
> Dear Postgre users,
>
>
> Im from Argentina and I have a question.
>
> im development a client-server application and i have a performance dude. I
> have a Db whit 10 tables. The server could attend a lot of clients at the
> same time and every client use this tables to insert rows. Every client is
> independent of the rest (dont share information). I want to know if is
> convenient create one schema for every user (10 tables from schema) or
> every users sharing the same schema (only 10 tables) Every user could
> insert a lot of rows per table.

Without more information, it is impossible to comment fully.  However, I would
generally use a single schema unless the data for each user is completely
private to that user.

Sean

pgsql-novice by date:

Previous
From: "Gustavo"
Date:
Subject: Help whit schemas
Next
From: Andreas
Date:
Subject: Re: Help whit schemas