Question about Performance of my db design

Поиск
Список
Период
Сортировка
От Gustavo
Тема Question about Performance of my db design
Дата
Msg-id 002901c7542b$4928dc50$e802a8c0@gustavo
обсуждение исходный текст
Ответ на Doubt about performance of my db design  ("Gustavo" <gustavor@intercomgi.net>)
Ответы Re: Question about Performance of my db design  (Sean Davis <sdavis2@mail.nih.gov>)
Список pgsql-novice
 
Hi
 
I have a question about the performance of my db design . I have this situation:
 
- One schema base containing 20 tables whit data of all users of my system. (These tables will contain a lot of rows (millions)). The data of each user is
independent of the rest
- One schema per user with a view of the schema base containing only the data of this user.
 
It is a good design? how efficient Does Postgree manage these big views? 
 
In the other hand, i have another idea:
 
- One schema whith the 20 tables and one schema per user whith tables that make inheritance of these.
 
If i do that, i avoid to make views.
 
What design is the best?
 
 Thanks, in advance
 
Gustavo ( sorry for my english)

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Gustavo"
Дата:
Сообщение: Doubt about performance of my db design
Следующее
От: Sean Davis
Дата:
Сообщение: Re: Question about Performance of my db design