[postgis-users] Multiuser system question

[Jan Hartmann]

Jan Hartmann wrote:

>> Alexander Pucher wrote:
>>
>>>
>>> I'm setting up a multiuser system with PostGIS and UMN MapServer. 
>>> When the user starts the system, a unique id is assigned to the session.
>>>
>>> I offer the user a selection of "default" geometry sets to work with. 
>>> During the session, the user can buffer geometries, which are stored 
>>> as new geometry tables in the system. To keep track of the various 
>>> users/tables, I have a kind of "lookup table", referencing the unique 
>>> id with the geometry tables.
>>>
>>> The question is a rather pragmatic one. Should I set up one 
>>> lookup-table and store all default tables along with all table 
>>> references that all users create, or create a seperate lookup table 
>>> for every session that is started? So consider 500 people with each 
>>> more then 20 geometry tables working on the system the same time. 
>>> What is more performant: all users working on one big table or 
>>> working on several smaller ones?
>>

On second thoughts: if your user group is small and you know them all 
beforehand, you can set up a schema for each user and drop all tables 
for that user in his schema. For classroom situations this works quite well.

Jan